Answered step by step
Verified Expert Solution
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 tables primary key will be used to link the tables. See example.
Make sure to provide written explanationsjustifications for your design and selection of the primary key for each table.
assignment table
Assignment requirement:
The assignment will need to be in an APA format
Assignment length should be pages long, not including the cover and reference pages
Assignment should have table designs new content
This content should be added to the paper that was created in Week and 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
Step 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