Question
(4) Consider an instructor's view of a class roster: Michael St. University CIS 3335 Database Fall Semester, 2016 Ticket number: 11365 Section: 1 Instructor id:
(4) Consider an instructor's view of a class roster:
Michael St. University
CIS 3335
Database
Fall Semester, 2016
Ticket number: 11365
Section: 1
Instructor id: 9944825
Instructor Name: Brett Kohs
Phone: 649-559-8913
(a) Design a minimal set of tables (and their columns) in at least 3NF to store this information.
(b) List the functional dependencies of each table.
(c) State the highest normal form (up to BCNF) of each table.
This is a Logical Database Design and Normalization Theory problem.
Studentld 1010111 2010012 1633285 5533992 5500000 StudentName Justin Smith Mary Johnson Kevin Kipp Michael Sports IT Colleen Harris Status Junior Senior Freshman Sophomore Junior Major Grade CIS CSCI CSCI CStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Repairing And Querying Databases Under Aggregate Constraints
Authors: Sergio Flesca ,Filippo Furfaro ,Francesco Parisi
2011th Edition
146141640X, 978-1461416401
