ENTREE_CODEENTREE_DESCRIPTIONDESERT_CODEDESERT_DESCRIPTIONEN3Stuffed crabDE8Chocolate moussewith raspberry sauceGiven the information in the table above:EN3Stuffed crabDE5Cherries jubileeEN5Marinated steakDE2Apple pie with honeycrusta) Given the table structure illustrated above, write its relational schema and draw its dependencydiagram. Label all transitive and/or partial dependencies. (Note: For this example, you can usethe table name and attribute names as given even though they don't strictly follow therelational schema naming conventions given in the notes. You can also create a shortenedversion of these attribute names if it is easier to work with).b) Break up the dependency diagram you drew in part (a) to produce dependency diagrams thatare in 3NF and write the relational schema. (Hint: You might have to create a few newattributes. Also, make sure that the new dependency diagrams contain attributes that meetproper design criteria; that is, make sure that there are no multivalued attributes, and so on.)c) Draw the Crow's Foot ERD to reflect the dependency diagrams you drew in Part (b). Q3. Suppose you are given the following business rules to form the basis for a database design. Thedatabase must enable the manager of a company dinner club to mail invitations to the club's members,to plan the meals, to keep track of who attends the dinners, and so on.Each dinner serves many members, and each member may attend many dinners.A member receives many invitations, and each invitation is mailed to many members.A dinner is based on a single entree, but an entree may be used as the basis for many dinners.For example, a dinner may be composed of a fish entree, rice, and corn. Or the dinner may becomposed of a fish entree, a baked potato, and string beans.Because the manager is not a database expert, the first attempt at creating the database uses thestructure shown in the table below:Attribute NameMEMBER_NUMMEMBER_NAMEMEMBER_ADDRESSMEMBER_CITYMEMBER_ZIPCODEINVITE_NUMINVITE_DATEACCEPT_DATEDINNER_DATEDINNER_ATTENDEDDINNER_CODEDINNER_DESCRIPTIONSample Value214Alice B. VanderVoort325 Meadow ParkMurkywater12345823-Feb-201627-Feb-201615-Mar-2016YesDI5Glowing sea delightSample Value235Gerald M. Gallega123 Rose CourtHighlight12349912-Mar-201615-Mar-201617-Mar-2016YesDI5Glowing sea delightSample Value214Alice B. VanderVoort325 Meadow ParkMurkywater123451023-Feb-201627-Feb-201615-Mar-2016NoD12Ranch Superb

Kindly note that you have posted multiple questions which are not inter-linked. As per our…

ENTREE_CODE ENTREE_DESCRIPTION DESERT_CODE DESERT_DESCRIPTION EN3 Stuffed crab DE8 Chocolate mousse with raspberry sauce EN3 Stuffed crab DE5 Cherries jubilee EN5 Marinated steak DE2 Apple pie with honey crust Given the information in the table above: a) Given the table structure illustrated above, write its relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. (Note: For this example, you can use the table name and attribute names as given even though they don't strictly follow the relational schema naming conventions given in the notes. You can also create a shortened version of these attribute names if it is easier to work with). b) Break up the dependency diagram you drew in part (a) to produce dependency diagrams that are in 3NF and write the relational schema. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes, and so on.) c) Draw the Crow's Foot ERD to reflect the dependency diagrams you drew in Part (b).

ENTREE_CODE ENTREE_DESCRIPTION DESERT_CODE DESERT_DESCRIPTION EN3 Stuffed crab DE8 Chocolate mousse with raspberry sauce EN3 Stuffed crab DE5 Cherries jubilee EN5 Marinated steak DE2 Apple pie with honey crust Given the information in the table above: a) Given the table structure illustrated above, write its relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. (Note: For this example, you can use the table name and attribute names as given even though they don't strictly follow the relational schema naming conventions given in the notes. You can also create a shortened version of these attribute names if it is easier to work with). b) Break up the dependency diagram you drew in part (a) to produce dependency diagrams that are in 3NF and write the relational schema. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes, and so on.) c) Draw the Crow's Foot ERD to reflect the dependency diagrams you drew in Part (b).

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to keep track of who attends the dinners, and so on. Each dinner serves many members, and each member may attend many dinners. A member receives many invitations, and each invitation is mailed to many members. A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn. Or the dinner may be composed of a fish entree, a baked potato, and string beans. A member may attend many dinners, and each dinner may be attended by many members. Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in Table I: Table I Sample RESERVATION Records Attribute Name Sample Value Sample Value Sample Value…
Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members, to plan the meals, to keep track of who attends the dinners, and so on. Each dinner serves many members, and each member may attend many dinners. A member receives many invitations, and each invitation is mailed to many members. A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn, or the dinner may be composed of a fish entree, a baked potato, and string beans. Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in Table P6.7.a. Given the table structure illustrated in Table P6.7, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. (Hint: This structure uses a…
Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to keep track of who attends the dinners, and so on. • Each dinner serves many members, and each member may attend many dinners. • A member receives many invitations, and each invitation is mailed to many members. • A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn. Or the dinner may be composed of a fish entree, a baked potato, and string beans. Draw the Crow’s Foot ERD to reflect the dependency diagrams you drew in Part c. (Note: You might have to create additional attributes to define the proper PKs and FKs. Make sure that all of your attributes conform to the naming conventions.)
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club’s members, to plan the meals, to keep track of who attends the dinners, and so on. • Each dinner serves many members, and each member may attend many dinners. • A member receives many invitations, and each invitation is mailed to many members. • A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn. Or the dinner may be composed of a fish entree, a baked potato, and string beans. Identify the functional dependencies.
Study the scenario and complete the question(s) that follow: JavaFX and Database ProgrammingPearson Institute of Higher Education (now Eduvos) has clinics on each of their 12 campuses. When a student goes to the clinic to receive medical attention, they need to be registered when it is their first time. Currently, they write the student details on paper and keep the details in physical files. Pearson management has contacted you to digitise the process of registering new patients at the clinics. They would like an application developed which will enable the clinic staff to register the patient digitally. The patient records should then be saved to a database. Create a JavaFX application using NetBeans for the Pearson Clinic. The application should have/do the following: 1. A graphical user interface (GUI) that will allow the user to enter the following details: Patient Name, Patient Surname, Patient ID Number, Patient Cell Number, Patient Student Number.2. The GUI should have an…
A database has been designed to display a list of popular movies and also a list of actors acting in these movies. The relationship that would exist between the related tables would be: O many to many one to many O many to one O one to one
Project Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…
A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, CIT 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class number…
Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE's Name (e.g., 'Texas', 'New York', 'California') and include the Region of the state (whose domain is {'Northeast', 'Midwest', 'Southeast', 'Southwest', 'West'}). Each CONGRESS_PERSON in the House of Representatives is described by his or her Name, plus the District represented, the Start_date when the congressperson was first elected, and the political Party to which he or she belongs (whose domain is {'Republican', 'Democrat', 'Independent', 'Other'}). The database keeps track of each BILL (i.e., proposed law), including the Bill_name, the Date_of_vote on the bill, whether the bill Passed_or_failed (whose domain is {'Yes', 'No'}), and the Sponsor (the congressperson(s) who sponsored that is, proposed the bill). The database also keeps track of how each congressperson voted on…
Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., ‘Texas’, ‘New York’, ‘California’) and include the Region of the state (whose domain is {‘Northeast’, ‘Midwest’, ‘Southeast’, ‘Southwest’, ‘West’}). Each CONGRESS_PERSON in the House of Representatives is described by his or her Name, plus the District represented, the Start_date when the congressperson was first elected, and the political Party to which he or she belongs (whose domain is {‘Republican’, ‘Democrat’, ‘Independent’,‘Other’}). The database keeps track of each BILL (i.e., proposed law), including the Bill_name, the Date_of_vote on the bill, whether the bill Passed_or_failed (whose domain is {‘Yes’, ‘No’}), and the Sponsor (the congressperson(s) who sponsored—that is, proposed—the bill). The database also keeps track of how each congressperson voted on…
PART C QUESTION 1 The NAN Book Rental Shop is seeking to implement a database system for its shop. The shop has customers known as members, and a collection of books available for rental. The purpose of the system is to track membership, book inventory, and book rental activities. The following are the current system descriptions associated with NAN Book Rental Shop. For each member, the data items that need to be recorded are: a unique membership identification number, the members' name, address, phone number and the date that the members joined the shop. • When a member rents a book, the shop will record these items: the book rental date, the book return due date, the date the book was returned, and the rental fee. Each member can rent a maximum of five books at any one time and the members must return the books in two weeks time. For each book, the book's identification number, title, type and rental price must be collected and stored in the system. Sometimes books are written by…

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS