Question

Create a database design according to the requirements below. The purpose of this database is to...

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.  

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

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
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A loan company wants to design a database to track student loans. Each student attending school...
A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the...
Create a student record management system With JAVA using linked list and queue using Java language...
Create a student record management system With JAVA using linked list and queue using Java language and (oracle or any) database to save files and GUI Java swing to create background The program will have the following properties: A. Register students ( assume each students has ID, first name, last name and middle name) B. Register students with courses ( course no ,course title chr ) C. Able to maintain grade on which course they are registered D. Searches students...
. Design an ER-diagram for a bank that implements the following requirements. The database you design...
. Design an ER-diagram for a bank that implements the following requirements. The database you design should store information about customers, accounts, branches and employees • Customer: Customers are identified by their SSN. For each customer we store a name, multiple phone numbers (one or more), and an occupation. • Account: Accounts are identified by an account number and the branch they belong to. For each account we store a balance and the type of account (e.g., savings). – An...
Consider the following set of requirements for a UNIVERSITY database that is used to keep track...
Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts. This is similar but not identical to the database shown in Figure 1.2: a. The university keeps track of each student’s name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications...
14.19. Suppose that we have the following requirements for a university database that is used to...
14.19. Suppose that we have the following requirements for a university database that is used to keep track of students’ transcripts: a. The university keeps track of each student’s name (Sname), student number (Snum), Social Security number (Ssn), current address (Sc_addr) and phone (Sc_phone), permanent address (Sp_addr) and phone (Sp_phone), birth date (Bdate), sex (Sex), class (Class) (‘freshman’, ‘sophomore’, … , ‘graduate’), major department (Major_code), minor department (Minor_code) (if any), and degree program (Prog) (‘b.a.’, ‘b.s.’, … , ‘ph.d.’). Both...
car dealership needs to design a database for their business. It is assumed there are three...
car dealership needs to design a database for their business. It is assumed there are three tables in the database with 6 fields in each table. Give your suggestions for the most necessary fields and their proper types, propertis and PK (primary key) / FK (foreign key) You can enlarge the answer window this way. Click in the answer box, then on the bottom right of the answer box, click on the triangle of dots icon and drag the window...
You are tasked to design the ER diagram for the database for the 3S clothing store....
You are tasked to design the ER diagram for the database for the 3S clothing store. Data requirements are as given below. • Information about 3S employees includes a unique employee ID, and his/her name and position. • Each customer of 3S is identified by a customer ID, and has a name. • Information about the suppliers of 3S include a unique name, and a contact phone number. • Clothes stocked by 3S are described by a product code, size,...
Data structures in java Implement the following classes: 1. class Course that includes three instance variables:...
Data structures in java Implement the following classes: 1. class Course that includes three instance variables: private String Name; // the course name private int ID; // the course ID private Course next; // the link Your class should have the following:  A constructor that initializes the two instance variables id and name.  Set and get methods for each instance variable. 2. class Department that includes three instance variables: private String deptName; private Course head, tail; Your class...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE TABLE Student (  sid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  address VARCHAR(20) NOT NULL,  major CHAR(2)); CREATE TABLE Professor (  pid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  department VARCHAR(10) NOT NULL); CREATE TABLE Course (  cid INT PRIMARY KEY,  title VARCHAR(20) NOT NULL UNIQUE,  credits INT NOT NULL,  area VARCHAR(5) NOT NULL); CREATE TABLE Transcript (  sid INT,  cid INT,  pid INT,  semester VARCHAR(9),  year YEAR,  grade CHAR(1) NOT NULL,  PRIMARY KEY (sid, cid, semester, year),  FOREIGN KEY (sid) REFERENCES Student...
There is one question listed below. Based on the content you have completed so far in...
There is one question listed below. Based on the content you have completed so far in this course, answer each question. After completing, submit this assignment to the M04 Lab Assignment link on IvyLearn. (40 points) With the information provided below, create a normalized ER diagram (third normal form) in draw.io for the entities in the Academic Database (School Management System). A good starting point for this question is to review your submission for the M03 Assignment, question #4. Add...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT