Let me know if you can complete this Project 2 and how much. Project 1 is attached.
Alozo.1
alonzo_simmons_project1.docxAlonzo Simmons, Jr.
CMIS 320
Project 1
Step 1) (7 points) Determine and list your entities. Then create relationship sentence pairs between those entities that are related. You should not have any many-to-many relationships.
ENTITIES
CUSTOMER
RENTALS
INVENTORY
RATES
MOVIES
STARS
RELATIONSHIPS
Each CUSTOMER charged for one or more RENTALS.
One or more RENTALS are charged to the CUSTOMER.
RENTALS rented from INVENTORY with each rental renting only one item from inventory.
INVENTORY rents one or more RENTALS.
RENTAL prices calculated using one, and only one RATE
INVENTORY purchased one or more MOVIES.
One or more MOVIES were purchased by INVENTORY.
(MediaType is either Video or DVD)
MOVIES made by STARS (Directors actors, etc.) and each movie made by one or more stars.
Mom and Pop Johnson Video Store Database E/R Diagram
Step 2) (13 points) Create an entity/relationship diagram (ERD) showing all your entities, attributes, and relationships. Sketch your ERD by hand or use a drawing program. Your diagram must be on a single page. All entities should be related to at least one other entity. Your ERD should have all one-to-many relationships and not have any many-to-many relationships.
Proposed Database Tables and Columns based on E/R Diagram
Step 3) (5 points) Create metadata that describes the table created from each entity and the column created from each attribute in the ERD. Particular attention will be given to the proper specification of all primary key (via "PK") and foreign key (via "FK") columns in the table layouts. These should match your ERD exactly.
|
CUSTOMERS |
|
|
CustomerID |
PK |
|
Name |
|
|
|
|
|
Address |
|
|
Phone |
|
|
RENTALS |
|
|
RentalID |
PK |
|
InventoryID |
FK |
|
CustomerID |
FK |
|
DueDate |
|
|
DateOut |
|
|
Rate ID |
FK |
|
RATES |
|
|
RateID |
PK |
|
RentalFee |
|
|
LateFee |
|
|
DamageFee |
|
|
INVENTORY |
|
|
InventoryID |
PK |
|
MovieID |
FK |
|
MediaType |
|
|
RentalStatus |
|
|
Distributor |
|
|
Price |
|
|
SerialNumber |
|
|
MOVIES |
|
|
MovieID |
PK |
|
Title |
|
|
Year |
|
|
Length |
|
|
Rating |
|
|
Nominations |
|
|
STARS |
|
|
StarID |
PK |
|
Name |
|
|
Role |
|
|
MovieID |
FK |
CustomerID
Name
Address
Phone
MovieID
InventoryID
Customer
Inventory
MediaType
RentalStatus
Movies
MovieID
Title
Length
Stars
Name
Rating
Year
Role
StarID
Made By
Purchased
Distributor
EntityRentals
RentalID
InventoryID
DateOut
DueDate
CustomerID
Rented
Charged
Price
Nominations
Rates
RateID
RentalFee
LateFee
DamageFee
RateID
SerialNumber
MovieID










