Question

a. Design a simple database with at least 5 relations for such applications as “students taking...

a. Design a simple database with at least 5 relations for such applications as “students taking courses taught by faculty in class rooms at a specific time”

b. Is the relation R in 3NF? Explain your answer using functional dependencies.

c. If your R above is in 3NF, create at least one table from your database that is not in 3NF. If your R is not in 3NF, decompose R into 3NF relations.

In each case, you are required to specify the primary keys and the functional dependencies that exist in each of the relations and thus, in the database with some discussions

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
a. Design a simple database with at least 5 relations for such applications as “students taking...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Decompose the given relation into relations in 2NF. For each of the new relations, draw a functional dependency diagram, and state if it is in 3NF and why. If your answer is no, describe how to normal...

    Decompose the given relation into relations in 2NF. For each of the new relations, draw a functional dependency diagram, and state if it is in 3NF and why. If your answer is no, describe how to normalise the relation to be in 3NF (c) The relation appointment is given below: appointment (patientID, patientName, patientAddress, aDate, aTime, nurseiD, nurseName, notes) where the primary key is underlined. It records the details of patient appointments with nurses. (i) Draw the functional dependency diagram...

  • The following are the main entity types of the academic institution database. For each entity type,...

    The following are the main entity types of the academic institution database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF,...

  • Consider the following relation R, where {A, B} is its PK. Assume that R is in...

    Consider the following relation R, where {A, B} is its PK. Assume that R is in the first normal form (INF). R (A, B, C, D, E, F) Functional dependencies: FD1: BàC FD2: AàDE FD3: ABàF Why is this table not in 2NF? Specify which FDs make R violate 2NF. Normalize the data shown in this table to second normal form (2NF). Specify the primary and foreign key (if any) in each table of your 3NF relations. Normalize the data...

  • DATABASES You are required to design and implement a relational database to help the local community...

    DATABASES You are required to design and implement a relational database to help the local community center better serve the residents in your neighborhood. Database Specifications: In your preliminary analysis, you have determined the following basic facts about the community center and the services it provides to the residents in the neighborhood: - The community center serves multiple areas which fall into different zip codes.  - The community center provides collaborative family based care services. An immediate family is...

  • Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date,...

    Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo) Some notes on the semantics of attributes are as follows: • Each project has a unique project ID (projID) and also has a title, type and manager. Each manager has a specialty project type. • A project often contracts jobs to contractors with start-date and end-date. Contracts are identified by contract numbers (contractNo), but contract details are out of the scope of...

  • DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed Apr...

    DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...

  • Design a database to keep data about college students, their academic advisors, the clubs they belong...

    Design a database to keep data about college students, their academic advisors, the clubs they belong to, the moderators of the clubs, and the activities that the clubs sponsor. Assume each student is assigned to one academic advisor, but an advisor counsels many students. Advisors do not have to be faculty members. Each student can belong to any number of clubs, and the clubs can sponsor any number of activities. The club must have some student members in order to...

  • Please see images for the database info. 1. Specify, in your own language, the project requiremen...

    Please see images for the database info. 1. Specify, in your own language, the project requirement; identify the different types of users; and different views from different user groups. 2. For #2, at least two user groups and a user view for each user group. Also, the following steps are for each user groups/user views until step 8 3. Illustrate your data modeling by using ER model. 4. Use a document of your own, determine the attributes; use your own...

  • (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...

    (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...

  • write the answer clearly thank you so much 1. Simple Technology, a Kansas based company, is...

    write the answer clearly thank you so much 1. Simple Technology, a Kansas based company, is working on a project to design and implement a database for tracking employees, their personal information, and information about projects. Some of the attributes that they want to store in the database is given as a tabular format below PC de PTitle PM nager PBudget PDept PD ation l Num EN Ed ity, EZ ED pt ED ptam eHRate P1 Payroll Martin 100K Accounting...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT