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,...
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...
Design ER diagram to capture the information below and explain fully your answer: The University has...
Design ER diagram to capture the information below and explain fully your answer: The University has to create a database. In design stage the committee formed the following description: “The research activity at the University is organized as series of projects: Each project has project number, budget, funding organization, staring date and completion date. Each project has a PI who is full time faculty at the university. Each project has only one PI, but can have one or more Co-PI...
HH, a headhunter company, wants to maintain candidate records and is particularly interested in tracking candidate...
HH, a headhunter company, wants to maintain candidate records and is particularly interested in tracking candidate education. This company now asks you to design a database system to track candidate education. For a candidate, the company needs to know candidateID, name, and address. The tracked candidates must attend colleges. Each candidate can attend different colleges or the same college at different time. The system needs to track information on the college name and location. For each attendance of a candidate...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT