Monday, January 22, 2018

Vince's Requirements (1 PM Class)

Requirements for Vince's Database
Album(AlbumID, Title, Year, studio)<=> Artist(ArtistID Artistname)
Track inventory (InventoryID, AlbumID, condition, pricepaid, DateAquired, Sale Price)
Record Purchases (vince purchasing)
Employees (employeeId, name, email)
Sales(SaleNumber, Date, EmployeeID, CustomerID (null))
SaleDetail(SaleDetailId, SaleNumber, InventoryID, Discount)
Customer(CustomerID, CustomerName, CustomerEmail)
Requests(Albumid, Date, CustomerID)

Requirements--something the database has to do to work successfully
Business Rules 150%, 25% discount for 10


No comments:

Post a Comment