(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
- Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified by Shipment#) uniquely identifies the shipment Origin, Destination, and Distance. The shipment Origin and Destination pair also uniquely identifies the Distance. Question: a. Develop a diagram that shows the functional dependencies in the SHIPMENT relation. b. In what normal form is SHIPMENT? Why? c. Convert SHIPMENT to third normal form if necessary. Show the resulting table(s) with the sample data presented in SHIPMENT.arrow_forwardHow does the primary key of a relation relate to the interdependencies of its characteristics from a functional standpoint?arrow_forwardConsider the advisor relation shown in the schema diagram in Figure 2.9, withs_id as the primary key of advisor. Suppose a student can have more than oneadvisor. Then, would s_id still be a primary key of the advisor relation? If not,what should the primary key of advisor be?arrow_forward
- In what three scenarios should a surrogate key be generated in place of a relation's primary key?arrow_forwardConsider the given ER Diagram for Notown database in Figure 2. You have been tasked to recommend that Notown use a relational database system to store company data. Show the Structured Query Language (SQL) statements for creating relations corresponding to the entity sets and relationship sets in your design. Identify any constraints in the ER Diagram that you are unable to capture in the SQL statements and briefly explain why you could not express them.arrow_forwardWhat is the relationship between the primary key of a relation and the functional dependencies among all attributes within that relation?arrow_forward
- Explain three scenarios in which a surrogate key for a relation's primary key should be generated.arrow_forwardDevelop an Entity Relationships Diagram (ERD) based on the relational schemas in the 3NF for the starting relational schema in un-normalized form presented below. UNF:Order(OrderID, OrderDate, CustID, CustName, CustPhone, CCNum, CCExpDate, CCBank, BnkContName, BnkContPhone, CustEmail, OrderIP, SiteRefFrom, ShipStreet, ShipCity, ShipSt, ShipZip, OrderLineNum, ItemID, ItemName, ItemDesc, ItemQtyOrdered,ItemListPrice, ItemSalePrice, ItemQtyShip, ShipCharge, Tax, TotalDue)arrow_forwardThree instances in which a surrogate key should be constructed for the relation's primary keyarrow_forward
- Transform the diagram to a relational schema that shows referential integrity constraintsarrow_forwardWhat is the connection between a relation's primary key and the functional relationships between all of its attributes?arrow_forwardDesign a Relational Database by Mapping the following Entity-Relationship Diagram (ERD) into Relational Model. You must clearly determine the PK of each relation. Also, you should show the links between FKs and PKs in your answer. SName Owner SHIP MOVEMENT PName HISTORY HOME PORT SHIP PORT Latitude (0,") VISITS (0.") Timestamp Longitude N N N (1.1) IN TYPE ON 1 1 Date Time StartDate VISITS Type EndDate Tonnage SHIP TYPE Name STATE/COUNTRY Name SEA/OCEAN/LAKE Hull Continentarrow_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 Learning