3. Figure 2 shows an Entity-Relationship (ER) diagram for a University dining servicea) Develop a relational schema.b) Show the functional dependencies.MENUEVENTMenu IDMenu DescriptionMenu TypeEvent IDServed atEvent DateEvent LocationEvent TimeSupervisesContainsDISHWORK SCHEDULESTAFFDish IDStart TimeEmp ID| NameSalary{Skill)Dish NameEnd TimeРrep Time{Ingredient)PositionFigure 2 University dining service

MENU( Menu ID, Menu Desciption, Menu Type) EVENT( Event ID, Event Date, Event Location, Event Time)…

Answered: 3. Figure 2 shows an…

3. Figure 2 shows an Entity-Relationship (ER) diagram for a University dining service a) Develop a relational schema. b) Show the functional dependencies.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

2) A relation schema R is defined tot be in 2NF if every nonprime attribute of R is blank the primary key of R.A) transitively dependent on B) fully functionally dependent onC) a candidate key of D) partially functionally dependent onE) part of
Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Note: Crow’s Foot Database Notation is required Question Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. areEach of these three entity types has a unique attribute identifier. The attributes that it stores are as follows: a. Salesperson Number(unique), SalespersoMaken Name, Salesperson Telephone, Hire Date b. Customer Number(unique), Customer Name, Customer Address, Value of Last Purchase c.Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie’s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct an ERD for Leslie’s Auto Sales. Make sure to denote your primary and foreign keys. Crow’s Foot Database Notation is required.Construct an ERD for Leslie’s Auto Sales. Make sure to…
The use of composite attributes are avoided in relation schema when the relation schema conforms to –(a) 1NF(b) BCNF(c) 3NF(d) 4NF
Develop 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)
Design an Entity-Relationship diagram for the below environment. determine 1-Total participation.2-Partial participation Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Question: Consider a relation named as BOOK that contains data about the books in a library. BOOK relation was initially created with the attributes BookID (an id that library assigns), ISBN, CopyNr (used to differentiate copies of the same book), Title, PublYear, Author, and AuthorBornYear. Primary key: BookID, CopyNr and Author Candidate key: ISBN, CopyNr and Author Below you see dependencies of attributes: Dependency 1 (D1): ISBN, Title, PublYear, AuthorBornYear were dependent on BookID, CopyNr, and Author Dependency 2 (D2): Title and PublYear were dependent on BookID, CopyNr Dependency 3 (D3): AuthorBornYear was dependent on Author First determine which normal form (1NF, 2NF, 3NF, or BCNF) the above relation is, and why. Then, if necessary, convert the above relation to the highest normal form (BCNF). Write any assumptions that you make Subject: MYSQL
According to the university database that we explain in the class, explain how functional dependencies can be used to indicate the following: • A one-to-one relationship set exists between entity sets student and instructor. A Many-to-one relationship set exists between entity sets student and instructor
DEL (30 %): Normalization:Let R bea relational schema and FR corresponding set of functional dependencies.R = ABCDEFR = {A → C, B → D, C → A}a) What normal form is the R schema in?b) Gradually normalize the scheme to 3NF, and for each new scheme, specify thekeys and associated functional dependencies
5.14 - Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, Ord_Amt) ORDER_ITEM (Order#, Item#, Qty) ITEM (Item#, Unit_price) SHIPMENT (Order#, Warehouse#, Ship_date) WAREHOUSE (Warehouse#, City) Here, Ord_Amt refers to total dollar amount of an order; Odate is the date the order was placed; Ship_date is the date an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouses. Specify the foreign keys for this schema, stating any assumptions you make. What other constraints can you think of for this database?
You are given a relation R with the following attributes R(A,B,C,D,E). Assume that you were given the following functional dependencies: • FD1= AB -> E • FD2: = D -> C (a) What is a valid key for this relation? justify your response. (b) Is this relation in 3NF (Third Normal Form)? Justify your response. If it is not in 3NF, normalize the relation and demonstrate all steps of normalization.
Consider a relation named as BOOK that contains data about the books in a library. BOOK relation was initially created with the attributes BookID (an id that library assigns), ISBN, CopyNr (used to differentiate copies of the same book), Title, PublYear, Author, and AuthorBornYear. Primary key: BookID, CopyNr and Author Candidate key: ISBN, CopyNr and Author Below is three dependencies of attributes: Dependency 1 (D1): ISBN, Title, PublYear, AuthorBornYear were dependent on BookID, CopyNr and Author Dependency 2 (D2): Title and PublYear were dependent on BookID, CopyNr Dependency 3 (D3): AuthorBornYear was dependent on Author . First determine which normal form (1NF, 2NF, 3NF or BCNF) the above relation is, and why. Then, if necessary, convert the above relation to the highest normal form (BCNF). Write any assumptions that you make.
52. Which functional dependency violates the 3NF requirements in a relational schema where attributes AA, AB, BC form a composite primary key and attribute EF is a single candidate key: R (AA, AB,CD, DE, EF, FG)? A: EF -> FG B: (AA, AB, BC) -> CO C: (AA, AB, BC) -> EF D: FG-> CO