• Consider the following scenario A company provides catering services for clients who need special-occasion, celebratory dinners. For each dinner, a number of dishes are to be offered. The dinner will be held at a venue. The company will provide staff to serve meals at the venue.The company needs a database to store data related to this business activity – Identify a list of entities – Identify pairs of entities where a direct relationship exist – For each pair of relationship draw the entity relationship diagram justifying the choice of cardinalities.

• Consider the following scenario A company provides catering services for clients who need special-occasion, celebratory dinners. For each dinner, a number of dishes are to be offered. The dinner will be held at a venue. The company will provide staff to serve meals at the venue.The company needs a database to store data related to this business activity – Identify a list of entities – Identify pairs of entities where a direct relationship exist – For each pair of relationship draw the entity relationship diagram justifying the choice of cardinalities.

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 2.1CTQ

See similar textbooks

Similar questions

Consider the ER diagram shown in Figure 3.22 for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans. a. List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify your choices. b. Suppose that every customer must have at least one account but is restricted to at most two loans at a time, and that a bank branch cannot have more than 1,000 loans. How does this show up on the (min, max) constraints?
Question 1: Normalization Please TYPE IF POSSIBLE OR WRITE CLEARLY Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X. Assume X has the following functional dependencies (X is one table with the attributes W, Y, S, M, F, E): WS è YMFE S è YME E è M In what normal form is relation X? Explain why? Is it possible to decompose X into a number of relations in order to achieve a higher normal form? Explain how (this means using English sentences and a diagram showing the final relation(s)).
Note: This question has been rejected three times now saying the question is incomplete. That's how the question is. Please do not reject it saying it is incomplete. The previous 4 questions were related. I was asked to provide question 3 but I will provide all of them. Question 1: Create the Entity Relationship (ER) Diagram for the following scenario. We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id…
Consider a database that includes the entity sets student, course, and sectionfrom the university schema and that additionally records the marks that studentsreceive in different exams of different sections.a. Construct an E-R diagram that models exams as entities and uses a ternaryrelationship as part of the design.b. Construct an alternative E-R diagram that uses only a binary relationshipbetween student and section. Make sure that only one relationship existsbetween a particular student and section pair, yet you can represent themarks that a student gets in different exams.
I am creating a database in which I would like to store information about my veterinary clinic. Iexpect to have customers bring in their pets for assessments. I also expect that thesecustomers will be charged a fee for assessments. Lastly, my staff will be able to prescribemedication for pets. Name at least 2 entity sets and 2 relationship sets that would exist in theER Model of this clinic.Also propose a primary key for one of the entity sets listed above
Read the following business rules carefully and use common sense when necessary to come up with a good database design as follows: 1- First, develop an ER model. Make sure to use meaningful entity names and relations. 2- Translate ER model into a set of tables, relations and constraints. 3- Label appropriate columns as primary keys and foreign keys. Business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history Each patient visit…
PLEASE TYPE IF POSSIBLE OR WRTIE ELIGIBLY Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X. Assume X has the following functional dependencies (X is one table with the attributes W, Y, S, M, F, E): WS è YMFE S è YME E è M In what normal form is relation X? Explain why? Is it possible to decompose X into a number of relations in order to achieve a higher normal form? Explain how (this means using English sentences and a diagram showing the final relation(s)).
Question 1 a) Give an example of three entities that might exist in a database for a medical office, and list some attributes that would be stored in a table for each entity. b) What is a relationship, and what three types of relationships exist? Give an example of each of the three types of relationships as per your example of entities in part (a) Question 2 Identifies the Entities and Draw an ER diagram for the following scenario: a) A college needs to track placement test scores for incoming students. Each student can take a variety of tests, including English and math. Some students are required to take placement tests because of previous coursework. b) Every employee in a company is assigned to one department. Every department can contain many employees. c) Data for an information technology conference needs to be collected. The conference has a variety of sessions scheduled over a two-day period. All attendees must register for the sessions they plan to attend. Some…
Consider the following Scenario.Design a database for an airline. The database must keep track of customers andtheir reservations, flights and their status, seat assignments on individual flights,and the schedule and routing of future flights. Your design should include an E-Rdiagram, a set of relational schemas, and a list of constraints, including primary-keyand foreign-key constraints.Please determine the entities, attributes and relationships that should exist in thedatabase and draw an E-R diagram.
Typically, a hospital patient receives medication that have been ordered by a particular doctor. Because the patient often receives several medication per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications , creating a 1:M relationship between ORDER and MEDICATION.a. Identify the business rules for PATIENT, ORDER and MEDICATIONb. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules.
Construct an ER Diagram from the following case study A new established company database needs to store information about employees (identified by NIC, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company.
For each of the following collection of entities, give the assumptions concerning the relationship between entities and attributes. EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) DEPENDENT(EMP_NUM, DEP_NUM, DEP_FNAME, DEP_DOB)