please send me solution of this complete questionsubject: DBMS A record company wishes to use a computer database to help with its operations regardingits performers, recordings and song catalogue. A requirements analysis has elicited the followinginformation:Songs have a unique song number, a non-unique title and a composition date. A song can be writtenby a number of composers; the composer's full name is required. Songs are recorded by recordingartists (bands or solo performers). A song is recorded as a track of a CD. A CD has many songs on it,called tracks. CDs have a unique record catalogue number, a title and must have a producer (the fullname of the producer is required). Each track must have the recording date and the track number ofthe CD. A song can appear on many (or no) CDs, and be recorded by many differentrecording artists. The same recording artist might re-record the same song on different CDs. A CDmust have only 1 recording artist appearing on it. CDs can be released a number of times,and each time the release date and associated number of sales is required.Use this information to design an appropriate EER model (If any assumptions then write those also),also convert EER model to tables with proper justification.

Entities identified are Song Composer, Artist Track CD. Attributes are: Song has Song number,…

Answered: please send me solution of this…

Engineering

Computer Science

please send me solution of this complete question subject: DBMS

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

G: Race conditions can be occurred in any computer program. Consider a group of two students develop a FYP project and maintain a database in it. One student calls an update( ) function on some data and at the same time second student calls update( ) on the same data to update the database. Describe what problem can be arise in the scenario and what might be done to prevent such problem?
Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded. Design an Entity-Relationship diagram for the above environment. Please indicate Cardinality Constraints and Participation Constraints
Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded. Design an Entity-Relationship diagram for the above environment.
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
Suppose we have a database for an university. The requirements are as follows: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. • Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s co-investigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. The FDs for the above requirements are given as, • PSSN →…
‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, last name, address) designated by the enterprise. This chief…
Your Division Head's point of view is as follows: "Pictures are stored in a database, and the basic design/structure we chose includes some very sensitive driver information." What if we placed it in its own folder, out of reach of people who shouldn't have access to it? What would your stance be, or, more precisely, which strategy would you prefer? It is necessary to present justification.
Q. Suppose we want to develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also examiners who must certify questions. List down the functional requirements of the above said system? Use Form based method for specifying “Make Quiz” functional requirement.
It is recommended that the following be covered in every training session for a new user of the school database:
Create a use case diagram for the following system: A video store (AVS) runs a series of faily standard video stores. Before a video can be put on the shelf, it must be cataogued and entered into the video database. Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for for three days at a time. Everytime a custmer rents a video, the system must ensure that this customer does not have overdue videos. Likewise, if the customer has returned overdue videos, but has not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos; if a video is two or more days overdue, the manager calls the customer to remind him or her to return the video. If a video is returned in damaged condition, the manager removes it from the video database and may somtimes charge the customer.
The readers and writers problem can be formulated in several ways with regard to which category of processes can be started when. Carefully describe three different variations of the problem, each one favouring (or not favouring) some category of processes. For each variation, specify what happens when a reader or a writer becomes ready to access the database, and what happens when a process is finished.