Consider a database for a university system that needs to store information about students, courses, and instructors. Each student can enroll in multiple courses, and each course can have multiple instructors. Normalize the following schema to Third Normal Form (3NF), and show your steps in between (1NF, 2NF). Students (StudentID, FirstName, LastName, CourseID, InstructorID) Courses (CourseID, CourseName, InstructorID) Instructors (InstructorID, FirstName, LastName)
3- Consider a
courses, and instructors. Each student can enroll in multiple courses, and each course can have
multiple instructors. Normalize the following schema to Third Normal Form (3NF), and show
your steps in between (1NF, 2NF).
Students (StudentID, FirstName, LastName, CourseID, InstructorID)
Courses (CourseID, CourseName, InstructorID)
Instructors (InstructorID, FirstName, LastName)
4- To keep track of office furniture, computers, printers, and other office equipment, the FOUNDIT
Company uses the table structure shown below.
a. Given that information, write the relational schema and draw the dependency diagram.
Make sure that you label the transitive and/or partial dependencies.
b. Write the relational schema and create a set of dependency diagrams that meet 3NF
requirements. Rename attributes to meet the naming conventions, and create new
entities and attributes as necessary.
Step by step
Solved in 3 steps
