Analysis of relational schemas and normalization Consider the following conceptual schema of a sample database domain that contains information about users, the type of users and the user's account of an application. (i) (ii) name address preferences [0..] (iii) (iv) USER DOB tel [0..] email [0..] NON-REGISTERED 1988 ID ID ID creates UserType REGISTERED regDate benefit [0..] USERACCOUNT userName password The following are partially completed collection of relational schemas. USER(name, address, DOB, tel[0..], email[0..]) USERACCOUNT (userName, password) NON - REGISTERED (preferences[0..]) REGISTERED(regDate, benefit [0..*]) ID Find all functional and multivalued dependencies in the relational schemas USER, USERACCOUNT, NON-REGISTERED, and REGISTERED. Find all minimal keys in the relational schemas USER, USERACCOUNT, NON-REGISTERED, and REGISTERED. List the derivations of all minimal keys. For each one of the relational schemas find the highest normal form a schema is in. List the justifications for each highest normal form found. Decompose all relational schemas that are not in 4NF into 4NF. List all relational schemas obtained from the decompositions. Remember to indicate the primary key and foreign keys (if any)

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Produce a relational schema diagram that corresponds to the linked ER diagram for a database for the television show Saturday Night Live (SNL). Your relational schema diagram should include primary and foreign keys. Often-times in database system development, requirements will change after the conceptual data model has been drafted: in your rela- tional schema diagram, add the following three additional attributes: attribute “birth.date" for the relation schema Host; attribute “start.date" for the relation schema Writer; and attribute “salary" for relation schema Cast Member. Please refer back to the requirements in Question 6, for additional details that may constrain the design of the relational schema model. Use the tool linked to create an image. Hints: please carefully note that "rerun date", “address", and “phone" are multi-valued attributes; how would those be depicted in the relational schema diagram? Also, please carefully note the many-to-many relationships; how would those…
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
The following relational database schema stores information about a restaurant. The primarykeys are underlined and field types are omitted. Study the schema and its correspondingdescription to answer the questionsCustomer (cid, cname, cage, caddress, cphone)Table (tno, capacity, availability)Item (iid, iname, price)Order ( oid, cid, iid, tno, quantity)Employee (eid, ename, eaddress, eage, salary)Reservation (rid, eid, cid,date, time)The customer is someone who eats in the restaurant. The Customer relation provides customer id, the name, age, address and phone number information. The Table relation gives the restaurant'soccupancy information that includes the table number, the number of people who can sit on thetable, and the table's availability information. The restaurant serves several items. Each of the Itemshas an identification number (e.g 82285), name (e.g, salad), and unit price (e.g.,$15). Soon afterarrival in the restaurant a customer places an order. Order relation contains…

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Concepts of Database Management

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS