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