For this project, design a 3NF database to contain data about the students, inst

Question

For this project, design a 3NF database to contain data about the students, instructors, and class offerings at your school. The database should consist of three tables (one each for students, classes, and instructors), and each table should have at least four fields. Select an appropriate primary key for each table and determine which of the tables will be related. Explain why your three tables are in 3NF. Also, design three query screens that might be used with this system; annotate each design with the table and field names for each piece of information to be included. Did any of your three designs utilize data from more than one table? If so, make sure that it is possible to do that, based on your table design and stated relationships. Be sure to include at least five sample records for each table in your design document.

Explanation / Answer

For school, the 3 tables required as :

The tables are not inter related to each other primarily but on some condition the joins can be performed to get the required data like the INST_ID of the CLASS_TEACHER of CLASS_NAME 'FIVE'.

The tables are in the third normal form as

Sample queries for these tables :

Here 2nd query use more than one table.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.