Summary: Planned Design For The Putts For Paws Tournament

566 Words3 Pages
MEMORANDUM SUBJECT: Planned Design for the Putts for Paws Charity Tournament Our annual Putts for Paws tournament is starting soon. As you know, this event raises fruns for the Santa Fe Animal Shelter. We need to track the data concerning this fundraiser closely in order to ensure we can donate the most money possible. I would like to create a new database that is dedicated to the tournament this year. I believe the database will have four tables. * Item table that lists the items, quantities, cost, and notes * OrderLine table that lists theorder number, line number, item, and quantity * Order table that lists the order number, the amount paid, how they paid * Participant table that lists the participants…show more content…
The relationship will be one-to-many. An Item will only appear once in the Item table, but that same item can be purchased many times in the OrderLine table. The Order Line Table will be linked to the Order table by the OrderID field. The relationship will be many-to-one. An Order ID will only appear once in the OrderLine table, but that same item can be purchased many times in the Order table. 1. Describe something (e.g., formatting, business rules, content, etc.) that makes this docx file an effective business document (explaining the database design). Explain why. 2. Describe something that makes the docx file an ineffective business document. Explain why. 3. Describe something that makes the database file an effective business database. Explain why. 4. Describe something that makes the database file an ineffective business database. Explain why. 5. List at least one skill or concept that you found new and/or helpful. Explain why. 6. List at least one skill or concept that you found hard, challenging, or confusing. Explain

More about Summary: Planned Design For The Putts For Paws Tournament

Open Document