Question

Create a database design according to the requirements below. The purpose of this database is to enable someone to select a high school and a Stanford degree program and see which courses can be completed at the high school and which are to be completed at Stanford.

Your database design will have multiple tables. Give each table an appropriate name. Name each field in each table appropriately.  Make sure each table is in third normal form. These are the requirements.

1. For each Stanford course, store the course ID and course name
2. For each Stanford degree program, store the program ID, program name, and the courses that are required to complete the degree
3. For each high school participating the College Credit Plus (CCP) program with Stanford, store the high school ID and the high school name
4. For each high school CCP course, store the high school ID, the high school course name, and the Stanford course ID that is equivalent to the high school course.

Create a document that shows your design using database design language (DBDL), and create an ER diagram to show your design.  

Answer 1

E-R Diagram-

• This Er model has 4 main entities-

1. high school
2. high school CCP course
3. Stanford degree program
4. Stanford course

• This Er model has has been converted into 3NF
• Here each entity and its attributes are in tabular form
• Data types of each attribute has been mentioned with it
• The primary key as PK and foriegn key as FK has been mentioned there.
• If any doubt, please feel free to ask and comment, i would like to answer them.
  Thank you