Create a normalization structure in 3nf

Reference no: EM133258832

Question 1: Dick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition, Dick would like the database to include each instructor's basic contact information, such as ID number, name, office location, and phone number. Currently, Dick has nine instructors (seven full-time faculty members and two adjuncts) in the department.

For each course, Dick would like to keep track of the course ID, title, and number of credit hours. When courses are offered, the section of the course receives an ID number, and with that number, the department keeps track of which instructor is teaching the course.

Finally, Dick needs to be able to keep track of the IT students and to know which courses each student has taken. The information he would like to know about each student includes ID number, name, and phone number. He also needs to know what grade the student receives in each course.

Dick has asked you to create an ERD from the information described above and then to create a normalization structure in 3NF.

Reference no: EM133258832

Questions Cloud

Give a brief summary evaluation of your community health : Give a brief summary evaluation of your community's health, the major strengths of your community, and the hopes for your community in the future

Create a numerical version of the binned variable : create a smoothed version of v. Choose a smoothing strategy to create a numerical version of the binned variable and explain your choices

Calculate the received power for a wireless communication : MTH St. John's University Calculate the received power for a wireless communication system for which the transmit power at the sender is 30dB, antenna gains

Choose and identify one such teaching : Choose and identify one such teaching and, using the Reading Guide information for John, offer some ideas as to how your discourse fits into John's Gospel

Create a normalization structure in 3nf : Dick has asked you to create an ERD from the information described above and then to create a normalization structure in 3NF

What is mary purpose in the story called the shining house : What is Mary's purpose in the story called The Shining Houses, Why would Munro have included her in this story?

Briefly describe five different leadership functions : Question - Given the fundamental value placed on leading with purpose, briefly describe five different leadership functions/situations

Identify one specific intervention strategy : Identify one specific intervention strategy and one specific remediation strategy you can implement in the "Clinical Field Experience D.

Write a query that uses a derived relation to find : Write a query that uses a derived relation to find the student(s) who have taken at least two courses in the Fall 2017 semester. Schema of the output should

User Account

All Pages