Busicorp is an online provider of software business objects. Authors create the objects and submit them to Busicorp for consideration. Customers purchase business objects by credit card or electronic payment service and then download the objects locally. The database does not contain object code, but does store the physical path tot he object and its documentation. authors are paid quarterly on a royalty basis.
Note: Royalty statements normally include an item breakdown. For the purpose of this project, you are concerned about quarterly royalty payments only, not item details.
The database should be documented through entity relationship diagrams. The database must be normalized to the third normal form. entity integrity must be enforced on all tables. XML deliverables must be well-formed XML documents.
Deliverables, Requirements and Timeline:
1) Basic database requirements. Prepare a list of possible entities for the database. Include a list of values that must be tracked for each entity. Identify any tables that would have related values.
2) Create an ERD for the initial entity list. Identify a primary key for each entity and establish relationships as appropriate. The entity list for this purpose is as follows:
Entity: Author
Attributes: Name, Address, AuthorID, Royalty payments.
Entity: Customer
Attributes: Name, Address, CustomerID