Exercise 1 . The following figure shows an initial data model for a small librar
ID: 3842444 • Letter: E
Question
Exercise 1.
The following figure shows an initial data model for a small library. It is incomplete, so as you answer the questions below consider what else might need to be included.
a. Explain to the librarian what the initial data model means.
b. Design tables for a relational database which would capture the information represented by the model. Include primary and foreign keys and other appropriate constraints.
Image URL :http://es.tinypic.com/r/2gshima/9
Or
Web Page: <a href="http://es.tinypic.com?ref=2gshima" target="_blank"><img src="http://i65.tinypic.com/2gshima.jpg" border="0" alt="Image and video hosting by TinyPic"></a>
Explanation / Answer
a)
Initial data model defines that how relational tables are represented and how the data is processed using query language. Storing or retreiving data is depends on constraints put on certain queries or table schema.
------------------------------------------------------------------------------------------------------------------------------------------------------------------
b)
Relationl database tables...
Item (Item_id (primary), title_id (foreign), copy_num, purchase_date)
Title(title_id (primary), cat_num, title, author, category_id (foreign))
Category (category_id (primary), name, type)
Person(ID (primary), last_name, first_name, Item_id(foreign))
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.