it 240 final project

Final Part 3/prototype.docx

Final Project Prototype

Submit:

--- The Word document you have been building for this project

with this assignment appended to it.

--Your prototype DB in SQLite3, or Access.

Part 3.

To help users evaluate your database vision and its usability, you generally create prototype queries and views (reports) to illustrate your specific design and its features. Create example queries and views (reports) in SQL; employing some sample data, verify your ER model(s) will support those use cases, or accomplishments, or activity, etc. demanded by your chosen area of application.

You may use SQLite3, or Access, to create your prototype.

Also, the included datatemplate.csv file shows how you might use the list from the San Juan SBC example to generate mock or made-up data for your project.

Do use made-up data.

Do not use data from a company you work for.

Make certain this section of your documentation includes:

1. The SQL for the tables you created

2. If you use Access, a copy of the Relationship

3. Copies of the SQL and results for all queries clearly identified as in this example:

Access
top 3 artists by playlist tracks (appearance)	top 3 artists by playlist tracks (appearance) CountOfArtist Artist 32 80s Chartstarz 12 Sam Cooke 5 Beach Boys 5 Bebe Rexha
SELECT Count(ARTIST.Artist) AS CountOfArtist, ARTIST.Artist FROM ARTIST INNER JOIN TRACK ON ARTIST.ArtistID = TRACK.ArtistID GROUP BY TRACK.ArtistID, ARTIST.Artist ORDER BY Count(ARTIST.Artist) DESC;

4. A working copy of your DB in SQLite3, or Access,