Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based upon the design criteria from the first two sections, and supporting diagrams, begin to layout the design of the tables of your database. In

Based upon the design criteria from the first two sections, and supporting diagrams, begin to layout the design of the tables of your database. In each table, determine the field names, field types, character length of each field and establish the primary key for each table. Once the tables are created, create a relationship diagram (as shown) to show how the table(s) primary key will be used to link the tables. See example.
Make sure to provide written explanations/justifications for your design and selection of the primary key for each table.
assignment 13 table
Assignment requirement:
The assignment will need to be in an APA format
Assignment length should be 1-2 pages long, not including the cover and reference page(s)
Assignment should have table designs (new content)
This content should be added to the paper that was created in Week 1 and 2 as we will continue to create a running document for the course design document. Here are my graphs or tables better put. +-------------------++------------------++------------------+
| Student || Course || Department |
+-------------------++------------------++------------------+
| StudentID (PK)|| CourseID (PK)|| DepartmentID (PK)|
| Name || Title || Name |
| DOB || Credits || Location |
| Major |+------------------+| Chair |
+-------------------+|+------------------+
||
||
||
+-------------------++------------------+
| Enrollment || Instructor |
+-------------------++------------------+
| EnrollmentID (PK)|| InstructorID (PK)|
| StudentID (FK)|--------| Name |
| CourseID (FK)|| DepartmentID (FK)|
| Grade |+------------------+
| Semester |
+-------------------+ Here is the tbale they are asking foror the example shown. It is the picture.Table name: STUDENT
(first four fields)
Table name: ENROLL
Table name: CLASS
(first three fields)
image text in transcribed

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 Systems For Advanced Applications 27th International Conference Dasfaa 2022 Virtual Event April 11 14 2022 Proceedings Part 2 Lncs 13246

Authors: Arnab Bhattacharya ,Janice Lee Mong Li ,Divyakant Agrawal ,P. Krishna Reddy ,Mukesh Mohania ,Anirban Mondal ,Vikram Goyal ,Rage Uday Kiran

1st Edition

3031001257, 978-3031001253

Students also viewed these Databases questions