Question: Task 1 : Database Design Create a design.pdf file which includes the following information: Provide your relational schema definitions in text form, including the attributes
Task : Database Design
Create a design.pdf file which includes the following information:
Provide your relational schema definitions in text form, including the attributes for each relation and the types of all the attributes. Make sure to clearly indicate your chosen keys including primary and foreign You are allowed flexibility on the exact attribute types you use for your schema, as long as they reasonably match the specification above eg in terms of number types, string types
Your schema should at least include:
Student table with student information
Course table with course details
Prerequisites table to track course prerequisites
Schedule table to track course meeting times and locations
Professor table with professor information
Teaching table to track which professor teaches which courses
Enrollment table to track student course enrollment
Provide an EntityRelation ER diagram that describes your schemas. please give me draw diagram I want drawing not the instruction please, give me all things is ask here.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
