(a)
The given diagram into a relational schema showing referential integrity constraint, the functional dependencies and transformation into 3NF.
(b)
Transformation of a given diagram into a relational schema showing referential integrity constraint and a diagram of the functional dependencies.
(c)
The given diagram into a relational schema showing referential integrity constraint, diagram the functional dependencies and transformation into 3NF if not in 3NF.
(d)
The given diagram into a relational schema showing referential integrity constraint and the diagram of functional dependencies and transformation into 3 NF.
(e)
Transform the given diagram into a relational schema showing referential integrity constraint, diagram the functional dependencies and transform into 3NF if not in 3NF.
Trending nowThis is a popular solution!
Chapter 4 Solutions
Modern Database Management (12th Edition)
- Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS). NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION. We want to build a database for a community of paleontologists, storing information about the fossils kept in different museums. Each fossil is described by the year and place of discovery, the name of the paleontologist who discovered it, the room where it is exposed, and the presumed species. Each fossil may be assigned to different species with different degrees of probability. Museums are characterized by their rooms, their paleontologists and…arrow_forward1.Consider the relation schema given in below fig. Design and draw an ER diagram that capture the information of this schema.(Analyse)(Apr/May 2017)Employee(empno,name,office,age)Books(isbn,title,authors,publisher)Loan(empno,isbn,date)Write the following queries in relational algebra and SQL.Find the names of employees who have borrowed a book published by McGraw-Hill.Find the names of employees who have borrowed all books published by McGraw-Hill.arrow_forwardWhat are three signs that a surrogate key should be generated for the primary key of a relation instead of using the main key?arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr