We want to replace the spreadsheet-based system with a new state- of-the-art computerized information system. EZMUSIC has more than 500 artists/bands in its portfolio and more than 2000 venues. is an artist management company that connects music artists with performing venues. Deadline: SQL Script: For your convenience, I attach below the original business requirements.Ĭlient's Project Requirements EZMusic Inc. When you're ready, upload your file on Blackboard. Include all the referential integrity constraints (PK/FK) Create at least 5 records for each table Create a view that shows how many artists are managed by each agent Create a view that shows all the invoices sent to each venue Create a view that shows how much money each artist earned Create a view that shows how much money EZMusic made from venue's fees Prepare one SQL script that checks all the above requirements.

The Physical Database Script (120 points) must: Work with the SQLite we have used during the semester Create all the tables, columns, primary keys, foreign keys, indexes, and views needed to deploy the business functionalities as requested by the client. I will evaluate each submission using the following criteria. In case something does not work as supposed, you must address the issues and specify the changes you would make to the EER and logical diagram to make the physical database work. Transcribed image text: Homework Instructions The deliverable must include a script that creates and populates all the tables as explained below in the list of requirements.

Sqlitestudio book