Suppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. • Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. • If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the generalization/specialization/aggregation. Identify the PK and provide a sample of FK in the diagram.

Suppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. • Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. • If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the generalization/specialization/aggregation. Identify the PK and provide a sample of FK in the diagram.

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

Assume that below given association is the required association between course provided and the student of the New York College. But this has several loopholes. 0,2,3 2.* Course Offering Student However, below is the complete table of registration entries of the fall semester that the above association allowed. Course Offering Student Course Offering Student Course Offering Student Homeothapy Beekeeping Beekeeping Homeothapy Homeothapy Beekeeping Fortune Telling Homeothapy Hattie Jaques Kenny Williams Joan Sims Fortune Telling Sid James Fortune Telling Hattie Jaques Joan Sims Beekeeping Vogon Poetry Beekeeping Jim Dale Kenny Williams Jim Dale Fortune Telling Joan Sims Hattie Jaques Charles Hawtrey Fortune Telling Charles Hawtrey Primal Screaming Hattie Jaques Kenny Williams Homeothapy Kenny Williams Fortune Telling Jim Dale Charles Hawtrey Your task is to identify 5 ways that the table of registration doesn't comply with the given association.
Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
Draw the associations that are described by the following business rules. Include the multiplicities for each relationship. (4 marks) A patient must be assigned to only one doctor, and a doctor can have one or many patient: An employee has one phone extension, and a unique phone extension is assigned to an employee. A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores around town.
Scenario – 2 Suppose that you are developing ERD about reality shows on TV. For each reality show, itsname, genre, basic_info and participants name. Any reality show has at least two or moreparticipants. Reality show may run for multiple days during the week. For each producer, thecompany name, company country is stored. A show is produced by exactly one producer. Andone producer produces exactly one show. For each television, its name, start year, head officeis stored. A television may broadcast multiple shows. Each show is broadcasted by exactly onetelevision. For each user, his/her username, password, and age is stored. A user may ratemultiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.Every show comes with Advertisement. Advertisement may belong to Single or more shows.Every advertisement will have customer who will pay for different packages for advertisements.Advertisements may vary from Reality show. Task to do: i. Identify Entities…
Give Authentic and relevant answer. DATABASE SYSTEMS Construct an Enhanced ERD along with Possible entity clusters of the given below system. This describes the business process to publish an academic paper. The author submits a paper to an editor of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor. The editor then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper.
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
1. Rick and Ryan Enterprises is an agency that specializes in representing clients in the fields of sports and entertainment. Given the nature of the business, some employees are given a company car to drive and each company car must be assigned to an employee. Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications. Company cars are identified by their vehicle ID and also contain a license plate number, make, model, and year. Employees represent clients. Not all employees represent clients while some employees represent many clients. Each client is represented by one and only one employee. Each client has a unique client number. Additional attributes required for each client are name, address, and date of birth. Draw an ER diagram that shows the entity types and the relationship types for Rick and Ryan Enterprises. While you must name each relationship type and define the structural constraints…
Consider the following requirements of a car rental company: A member may rent more than one car and a car can be rented by more than one member in a given period. Cars are classified into categories (For example; economy, premium, SUV). A car is assigned to only one driver, but a driver can drive many cars. A car can only belong to one category, but a category can have one or more cars. Details of car rent must be recorded to reflect the rent duration and cost. 1. What are the possible entities in this business case? 2. Suggest 2 relationship names that might exist between the entities 3. List at least 2 attributes of each entity?
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to theWashington, D.C. area. In recent years, LOST has grown quickly and is havingdifficulty keeping up with all of the various information needs of the company. Thecompany’s operations are as follows:LOST offers many different tours. For each tour, the tour name, approximatelength (in hours), and fee charged is needed. Guides are identified by anemployee ID, but the system should also record a guide’s name, home address,and date of hire. Guides take a test to be qualified to lead specific tours. It isimportant to know which guides are qualified to lead which tours and the datethat they completed the qualification test for each tour. A guide may be qualifiedto lead many different tours. A tour can have many different qualified guides.New guides may or may not be qualified to lead any tours, just as a new tour mayor may not have any qualified guides.Every tour must be designed to visit at least three…
A library has books, journals, and periodicals that it loans to its users. All library material has an accession number which is a unique identifier and a price. In addition, a book has a title, publisher, year of publication, edition, and authors. Journals have journal name, volume number, issue number and year of publication. Each article in a journal has a title and authors. A periodical has a name and date of publication. The library keeps one or more copies of each library item (book, journal, periodical). Copies of all library material can be loaned to users. Reference-only material is loaned for 2hrs and can’t be removed from the library. Other material can be loaned for 2 weeks. For every loan, the library records the user, the loan date and time, and the return date and time. For users, the library keeps their name, address, and cell phone number. If a user loses a loaned item they are made to purchase it, however, if the user delays with the loaned item they are finned…
Exercise 3: school system Each subject is owned by a department and each department is managed by a teacher, called Head of Department (HOD). Each department has a name and a unique code number. Each subject has a name, unique number and credit value. All teachers have a unique ID. A HOD cannot manage more than one department at a time. Also, a HOD does not teach subjects. A subject cannot be taught by more than one teacher. Finally, the system needs to know each student's contact details, including, full ID, address, age and gender, as well as date of enrolment in the subject. name, student