Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Simple Technology, a Kansas based company, is working on a second project to design and implement a database for tracking vital information for an

image text in transcribed

2. Simple Technology, a Kansas based company, is working on a second project to design and implement a database for tracking vital information for an educational institution. Some of the attributes that they want to store in the database is given as a schema format below. Although a sample raw data was not made available, some of the assumptions were also given to assisting the database design process. R (Student ID, Last Name, First name, Course ID, Course Section, Course Name, Grade, Instructor Last Name, Instructor First Name, Building, Office No) Assumptions: - Student ID is computer generated and unique - A course can have multiple sections - An office is assigned to only one instructor and an instructor can have only one office. Using straight-to-BCNF process normalize the above relation to BCNF. Make sure yo follow the four step process. Show your work. List final set of relations that are normalized to BCNF. Include schemas for each of the final set of relations. Indicate all the primary, foreign, and surrogate keys in the final schemas. (40 points) a) 2. Simple Technology, a Kansas based company, is working on a second project to design and implement a database for tracking vital information for an educational institution. Some of the attributes that they want to store in the database is given as a schema format below. Although a sample raw data was not made available, some of the assumptions were also given to assisting the database design process. R (Student ID, Last Name, First name, Course ID, Course Section, Course Name, Grade, Instructor Last Name, Instructor First Name, Building, Office No) Assumptions: - Student ID is computer generated and unique - A course can have multiple sections - An office is assigned to only one instructor and an instructor can have only one office. Using straight-to-BCNF process normalize the above relation to BCNF. Make sure yo follow the four step process. Show your work. List final set of relations that are normalized to BCNF. Include schemas for each of the final set of relations. Indicate all the primary, foreign, and surrogate keys in the final schemas. (40 points) a)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions

Question

DESCRIBE the five basic elements of compensation for managers.

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago