The following table shows a table called Grade Report for a university. The existing functional dependencies are described as follows
Using Microsoft Word, complete the following:
The following table shows a table called Grade Report for a university. The existing functional dependencies are described as follows:
Student_ID -> Student_Name, Major
Course_ID -> Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location
Deliverable:
Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.
In what normal form is this table? Explain why.
Decompose the table into a set of 3NF tables. Describe the process to decompose the table.
Draw an ER diagram based on the decomposed tables (in Chen model).
Table: Grade Report
Student_ID
Student_ Name
Major
Course_ID
Course_Title
Instructor_Name
Instructor_Location
Grade
168300458
Williams
IT
ITD320
Database Imp
Codd
B104
A
168300458
Williams
IT
ITP310
Programming
Parsons
B317
B
543291073
Baker
Acctg
ITD320
Database Imp
Codd
B104
C
543291073
Baker
Acctg
Acct201
Fund Acctg
Miller
H310
B
543291073
Baker
Acctg
Mktg300
Intro Mktg
Bennett
B212
A
These shown Dependencies have been included in a .jpeg file for better order.
- Plain text response
- Attached file(s):
- database.doc
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Draw dependence diagrams - The following table shows a table called Grade Report for a university. The existing functional dependencies are described as follows: Student_ID -> Student_Name, Major Course_ID -> Course_Title, ...
- Develop database tables using a relational database system - The following table (Attached) shows a table called Grade Report for a university. The existing functional dependencies are described as follows: Student_ID -> Student_Name, Major Course_ID -> Co ...
- Relations in the 3NF. - For each of the following relations, indicate the normal form of the relation. Put each relation in the 3NF. a. COURSE (course_id, lab_id, equipment_type), primary key = {course_id, ...
- Implement the spreadsheet in the MS access and list all assumptions and functional dependencies - (See attached file for full problem description) --- Implement the database in MS access with Relationships, tables, keys, indexes and a view(query) that duplicated the spreadsheet and list all fu ...
- Relational schema diagram (ID all dependencies to include transitive) - Using the STUDENT table structure attached, write the relational schema and draw its diagram. Identify all dependencies (including all transitive dependencies)
