please help answer with little bit explain Simple Technology, a Kansas based com
ID: 3755484 • Letter: P
Question
please help answer with little bit explain
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. (40 points) 2. R = (Student ID, Last Name, First name, Course ID, Course Section, Course Name, Grade, Instructor Last Name, Instructor First Name, Office ID, Building, Office No) Assumptions - Student ID is computer generated - A course can have multiple sections - An office is assigned to only one instructor and an instructor can have only one office. a) Write all functional dependencies for the above relation. b) Using step-by-step process normalize the above relation to BCNF. Make sure you go through all normalization steps from 1NF to BCNF. Show your work. You must indicate all anomalies lead to the violation of each normalization conditions. List final set of relations that are normalized to BCNF. Include schemas for each of the final se surrogate keys in the final schemas. t of relations. Indicate all the primary, foreign, andExplanation / Answer
Functional dependency: If the primary key (PK) attribute uniquely identifies the non-primary key attribute of the same table then the non-primary key attribute is said to be functionally dependent on the primary key attribute. If column1 is the primary key and column2 is the attribute which is functionally dependent on the primary key then it is usually represented as column1 -> column2
Assuming that StudentID is the PK for student table, CourseID is the PK for course table, officeID is the primary key for Office table.
2(a)
StudentID -> Last Name, First Name
CourseID -> Course name
OfficeID -> Building, office No, instructor last name, instructor first name
(The left side attribute is determinant and the right side attribute(s) is dependent)
For that Relation R
StudentID -> Last Name, First Name, Course Section, Course Name, Grade
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.