Please Help It Is Urgent I Will Apricate It 1 (74.3 KiB) Viewed 37 times
Please Help It Is Urgent I Will Apricate It 2 (66.09 KiB) Viewed 37 times
Question 2: Normalization (15 points) Consider the following relational table with given sample data. CourseID CourseName Quarter BuildingID BuildingName Room Number 373 Database Applications Fall 2019 CNY05 Patterson 248 374 Spreadsheet Modeling Fall 2019 CNYOS Patterson 225 374 Spreadsheet Modeling Winter 2020 RPT03 Business 209 481 Systems Analysis and Winter 2020 RPT03 Business 209 482 Systems Project Spring 2020 CNY05 Patterson 248 485 Advanced Databases Spring 2020 225 RPT03 Business The table captures the data about classroom assignment for each course in a certain quarter. The
e underlined attributes form the composite) primary key of the table. STRA Each course has a course ID, which is unique, and a course name. Each building has a building ID, which is unique, and a building name.moragi Each classroom is located in a building. Different classrooms in different buildings may have the same room number. In a quarter, each course is assigned to only one classroom. a a) Specify full key functional dependencies, partial dependencies, and transitive dependencies in this ta b) Show the result of normalizing this table to 2NF with data. c) Show the result of normalizing this table to 3NF with data. Please submit a Word file.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!