Does this database schema look right? From what these steps are asking me? • Each musician that records at Sun City has an SSN, a name, anaddress, and a phone number. SSN uniquely identifies a musician.• Each instrument used in songs recorded at Sun City has a uniqueidentification number, a name (eg. guitar, flute) and a musical key(eg. C, B-flat, E-flat).• Each song recorded at Sun City has a title and a date. Songs areuniquely identified by a song id.. There are two types of musicians recording a song: vocalists andinstrumentalists.• Each instrumentalist may play several instruments, and a giveninstrument may be played by several instrumentalists. Eachinstrumentalist plays at least one musical instrument. Eachinstrument must be played by some instrumentalist.• Each song is performed by one or more musicians, and a musicianmay perform a number of songs.• Each musician who performs a song receives a payment.• Each song must be performed by some musician.• A singer has a type (eg. baritone, tenor, and soprano).• Singers do not play any instruments.The set of singers and the set of instrumentalists are disjoint.Lo (PhoneA trace (Loan)(Musician(11m)Instrumen's Chnsmusicalkeyка4 Play:CSSNSingerEmiltypeCin)InstrumentalistsPerformSongSonsid(parmintdateGitk

The question asks to create an Entity-Relationship Diagram (ERD) for Sun City Music Recording Studio…

Answered: s this database schema look right? From…

Engineering

Computer Science

s this database schema look right? From what these steps

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

COLLEGE (CollegeName, ZipCode, CarnegieClass)LECTURER (LectureID, Name, Email, PhoneNumber)EXPERTISE (TopicOfExpertise, LevelOfExpertise, LecturerID)CONTRACT (ContractDate, CollegeName, LecturerID, Salary)ZIP (ZipCode, City, State) Also assume that there are frequent queries involving the following information:a. List of colleges sorted by zip code.b. Access to information on a specific lecturer—their name, email address, and phone number.c. List of lecturers sorted by their area of expertise and within each area of expertise, their expertise level.d. List of colleges sorted by their CarnegieClass and within the CarnegieClass by zip code.e. Access to information on a specific lecturer based on their email address. For each situation above, specify the types of index(es) you would recommend. Justify your decisionsbased on the given relational model.
COLLEGE (CollegeName, ZipCode, CarnegieClass)LECTURER (LectureID, Name, Email, PhoneNumber)EXPERTISE (TopicOfExpertise, LevelOfExpertise, LecturerID)CONTRACT (ContractDate, CollegeName, LecturerID, Salary)ZIP (ZipCode, City, State) Also assume that there are frequent queries involving the following information:a. List of colleges sorted by zip code.b. Access to information on a specific lecturer—their name, email address, and phone number.c. List of lecturers sorted by their area of expertise and within each area of expertise, their expertise level.d. List of colleges sorted by their CarnegieClass and within the CarnegieClass by zip code.e. Access to information on a specific lecturer based on their email address. For each situation above, specify the types of index(es) you would recommend. Justify your decisionsbased on the given relational model. This model is by normal form
Create a MySQL stored procedure to validate an attempt to create a new submission table. The stored procedure should have parameters for the user, the user’s password, the id of the problem, the programming language (as varchar), and the source code. An output parameter returns the result of the submission, which is one of the strings that the program can return, or “Bad Parameters”, which handles cases such as the incorrect password for the user, or the attempt to submit using a language that the program does not support (e.g., Malbolge or Visual Basic). The stored procedure can simulate the program's judging process: if there is no Bad Parameters error, then randomly choose between Accepted, Wrong Answer, Time Limit Exceeded, and Run Time Error with equal probability. The submission gets
Fragment the Client table so that clients of Consultant 19 form a fragment named ClientConslt19, clients of Consultant 22 form a fragment named ClientConslt22, clients of Consultant 35 form a fragment named ClientConslt35, and clients of Consultant 51 form a fragment named ClientConslt51. (Include all fields from the Client table in each fragment.) In addition, you need to fragment the WorkOrders table so that orders are distributed and stored with the clients that placed the orders. For example, fragment OrdersConslt19 consists of those orders placed by clients of Consultant 19. Write the SQL-type statements to create these fragments.
List minimal cover and identify all possible candidate keys. A → BC IG → B C → DE ED → GJF HD → C AG → J AD → F DEC → G
Create a MySQL stored procedure to validate an attempt to create a new submission. The stored procedure should have parameters for the user, the user’s password, the id of the problem, the programming language (as a varchar), and the source code. An output parameter returns the result of the submission, which is one of the strings that can return or “Bad Parameters”, which handles cases such as incorrect password for the user, or the attempt to submit using a language that the program does not support (e.g., Malbolge or Visual Basic). The stored procedure can simulate the program judging process: if there is no Bad Parameters error, then randomly choose between Accepted, Wrong Answer, Time Limit Exceeded, and Run Time Error with equal probability. The submission should gets recorded in the database.
Please I want the EER or E-R Digram for this question: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. • We must record the checkback date for Emergency patient. • Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. • Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. • Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions…
Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.). BranchNbr stores RefNbr of either 'D', OR 'W' transactions, and MerchantNbr stores RefNbr of either 'B', 'P' or 'R' transactions. Provide an alphabetic list by last name of all Clients showing their full name (e.g., Bob Barlow), with the number of Accounts they hold and the total balance of those Accounts Provide a count and total amount of Transactions for each Type Description PLEASE DONT NOT COPY THE EXISTING SOLUTION ON BARTLEBY IT IS WRONG AND DOES NOT WORK AND IS INCOMPLETE. GIVEN THE BELOW: --THIS CREATES THE BANK BRANCH TABLE: CREATE TABLE BankBranch ( BranchNbr INT PRIMARY KEY, BranchName VARCHAR(250)); --THIS CREATES THE MERCHANT TABLE: CREATE TABLE Merchant ( MerchantNbr INT PRIMARY KEY, MerchantName VARCHAR(250)); --THIS…
Create a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.). BranchNbr stores RefNbr of either 'D', OR 'W' transactions, and MerchantNbr stores RefNbr of either 'B', 'P' or 'R' transactions. Provide an alphabetic list by last name of all Clients showing their full name (e.g., Bob Barlow), with the number of Accounts they hold and the total balance of those Accounts Provide a count and total amount of Transactions for each Type Description PLEASE DONT NOT COPY THE EXISTING SOLUTION ON BARTLEBY IT IS DOES NOT WORK AND IS INCOMPLETE. GIVEN THE BELOW: --THIS CREATES THE BANK BRANCH TABLE: CREATE TABLE BankBranch ( BranchNbr INT PRIMARY KEY, BranchName VARCHAR(250)); --THIS CREATES THE MERCHANT TABLE: CREATE TABLE Merchant ( MerchantNbr INT PRIMARY KEY, MerchantName VARCHAR(250)); --THIS CREATES THE…
Consider the below given iris data set. This dataset contains 3 classes of 15 instances each and each class refers to a type of iris plant. The dataset has two features: sepal length, sepal width. The third column is for species, which holds the value for these types of plants. A new plant is identified. You have to classify the Species class of new identified plant with the help of KNN algorithm. Note: Before applying KNN modify the given data by adding last two digits of your registration number. Such as if the last two digits of your registration number is 23 then first row in the given table will be 28.3and 26.3.
Question 13 Given the following declaration of records and the name of the records, write the full program to create two records and assign values based on the following details.table parttime stname(ahmed hassan) , stadress(Dubai)stphone(052772711)CGPA(3.56) Question13 table 2 table name fulltime stname(nuha Ali)stadress(abudhabi)stphone(0542227222)CGPA(3.88)
Use the following DBDL that contains 4 entities in 3NF to create a Crow's Foot ERD (use the name of entities and attributes mentioned in DBDL) . titleAuthor [ titleCode , authorID, sequence ] FK titleCode -> Title FK authorID -> Author Author [ authorID, authorFName, authorLName ] Title [ pubCode, titleCode, titleName, price ] FK pubCode -> Publisher Publisher [ pubCode, pubCompany]