In the title of your email please use the following
format:
Class :: Your Name :: Project
Section 5/Chapter 4
10 pts - Create ten multiple choices questions with answers for this
chapter and email them to the instructor.
40 pts - Do all questions.
30 pts - Model 1: Create a Entity Relationship Diagram Chen Model
Please choose one of the two following data sets to model.
VIDEO GAME:
Entities:
- Consoles
- Games
- Complete/Won
- Achievement
- Player
Attributes
- Consoles
- Console_id
- Name
- Year Purchased
- Cost
- Player_id
- Game
- Game_id
- Name
- Company
- Cost
- Purchased at
- Player_id
- Complete/Won
- Complete_id
- Date Complete
- High Score
- Player_id
- Game_id
- Achievements
- Game Id
- Player_id
- Name
- Description
- Player
- Player_id
- Name
- Address
- Phone
RESTURANT:
Business Rules
A restaurant can have many employees.
A restaurant can have many menu items
A restaurant can have many awards
A restaurant can have many Suppliers
A Supplier can have many Restaurant
A Employee can only have one Restaurant
Menu items can be served at many Restaurants
Awards can be given to many Restaurants
·
Entities:
Restaurant
Menu items
Employees
Suppliers
Awards
Attributes:
Restaurant
o
Restaurant Id
o
Name
o
Year Started
o
Annual Revenue
o
Manager Employee Id
·
Menu items
o
Menu id
o
Name
o
List Price
o
Cost
·
Employees
o
Employee id
o
Name
o
Salary
o
Start Date
o
Title
·
Suppliers
o
Supplier id
o
Name
o
Address
o
Phone
·
Awards
o
Award Id
o
Name
o
Date Awarded
o
Company Awarding
15 pts - Model 2: Rereate a the above Entity Relationship Diagram Crow Foot Model
20 pts - Now take the model and create it MYSQL database using mysql commands or Navicat
- Do a minumum of 2 inserts per table.
|
