build an Access relational database

build an Access relational database that will be the repository for data to run an on-line Internet music website. Your database will not have to be so complete that it would run all of such a website. (If you worked for this type of organization and were in charge of their database(s), you would probably find that there is far more data required to run their website than we would ever guess.) What to store: You need to store data about 5 song collections (and their associated songs, artists, and bands, if any). What to hand in: You will need to hand in the following deliverables for your semester project: 1. _Write-up_ that: 1) describes your project group, the organization that you're doing the work for, the database contents (tables, fields, queries, etc.) 2) is 3 pages maximum! 2. Printout showing your database _structure_ 3. Printout of 3 _queries_ 4. Printout of your _data entry forms_ 5. Printout of 3 _reports_ 6. _Floppy disk_containing all of the above (and _NO_viruses) you will be penalized if there is a virus on your disk you can compress your database using Access's: Tools/Database Utilities/Compact and Repair Due date: The semester project deliverables are due on Friday, May 14th, 2004 at 5:00 PM Pacific Standard Time _exactly_. **Formatting of Deliverables for Semester Project for ISYS 363, Spring, 2004** (Beckman) Due to the very large number of semester projects that I will be receiving and will have to grade, I am putting into place a fairly rigid formatting procedure for the deliverables associated with the semester project. If your project group does not follow this format for your project deliverables, I will reduce your semester project score by 5 points. Using this formatting process will also ensure that all of the parts of your semester project are in place. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform **General formatting rules:** Page 1, line 1: The title of your project (if any). Page 1, next: Your semester project group members (in alphabetical order). Pages 2-5: Write-up (3 pages _maximum_) Next 1 page: Graphic display of your database structure Next pages: Your database queries Next pages: Your data entry screens Next pages: Your database reports Next pages: Any supporting materials (details of database tables, queries, data entry screens, reports, etc.) Last page: Envelope containing your database stored on a floppy disk; don't use other storage media. You can compress your database to fit on a floppy disk by using the Access menu selections: Tools/Database Utilities/Compact and Repair Database...