![]() EZMUSIC has commissioned your team to design and develop a database application. ![]() A local company manages this infrastructure and provides the required support. Its technology infrastructure consists of a variety of desktops, printers, laptops, tablets, and smartphones all connected with a simple wired and wire-less network. Finally, EZMUSIC pays the artist after deducting its own fees. After the performance, EZMUSIC sends an invoice to the venue, who sends a payment to EZMUSIC (note that EZMUSIC requires a security deposit, but you do not need to capture that aspect in your system). EZMUSIC maintains the artists' calendars and responds back based on the requested artist's availability. EZMUSIC markets its artists to the venues in this process, a venue normally requests a specific artist for a specific date. New contracts are issued annually to all artists. When EZMUSIC management decides to propose a contract to a prospect, it first sends the artist a tentative contract, and if the response is positive, a final contract, is mailed to the prospect. EZMUSIC employees collect information regarding promising prospects and maintain that information in the system. These reviews are used to keep a list of favorite artists for each venue. Each venue is classified for the preferred music genres, and EZMUSIC keeps the venue's reviews of the artists that played in each venue. EZMUSIC receives information regarding possible new artists both from promising young artists themselves and as recommendations from current artists and a network of music critics. For example, it needs to keep track of prospective artists. ![]() To accomplish this objective, EZMUSIC needs technology support for several tasks. In addition, EZMUSIC receives a fixed fee from the venues (the fee varies by venue and is based on an annual agreement between EZMUSIC and each venue). The core business idea is simple: EZMUSIC finds paid performance opportunities for the artists whom it represents at venues that are connected with EZMUSIC and receives a 5 to 15 percent royalty for all the fees the artists earn (the royalties vary by artist and are based on a contract between EZMUSIC and each artist). 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. 0 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Ĭlient's Project Requirements EZMusic Inc. ![]() ![]() 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. Transcribed image text: Homework 3 Instructions The deliverable must include a script that creates and populates all the tables as explained below in the list of requirements. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |