Q 1. Construct an E-R diagram using structural constraints (cardinality ratio and participation) for a book stock management system based on the following information: • Books are written by authors & published by the publishers. Shopping basket contains books. Warehouse stocks books. Customer takes book from shopping basket. • Author is uniquely identified by name. It also consists of address and URL. • Book is uniquely identified by ISBN. It also consists of year, title and price. • Publisher is uniquely identified by name. It also consists of addresses (multiple), phone and URL. • Customer is uniquely identified by email. It also consists of name, address and phone. • Shopping basket is uniquely identified by basket id. It also consists of name. • Warehouse is uniquely identified by code. It also consists of address and phone. • Some authors write many books. A publisher can publish many books. Many books can be stocked in a warehouse. A customer can have many shopping baskets. A shopping basket

Q 1. Construct an E-R diagram using structural constraints (cardinality ratio and participation) for a book stock management system based on the following information: • Books are written by authors & published by the publishers. Shopping basket contains books. Warehouse stocks books. Customer takes book from shopping basket. • Author is uniquely identified by name. It also consists of address and URL. • Book is uniquely identified by ISBN. It also consists of year, title and price. • Publisher is uniquely identified by name. It also consists of addresses (multiple), phone and URL. • Customer is uniquely identified by email. It also consists of name, address and phone. • Shopping basket is uniquely identified by basket id. It also consists of name. • Warehouse is uniquely identified by code. It also consists of address and phone. • Some authors write many books. A publisher can publish many books. Many books can be stocked in a warehouse. A customer can have many shopping baskets. A shopping basket

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

answer should be handwritten and the ER MODEL should be be completeDraw the Entity Relationship Diagram (ERD) with appropriate mapping cardinalities for the following scenario, Patients are treated in a single ward by the doctors assigned to them. Healthcare assistants also attend to the patients; a number of these are associated with each ward. Each patient is required to take a variety of drugs a certain number of times per day and for varying lengths of time. The system must record details concerning patient treatment and staff payment. Some staffs are paid part time and doctors and healthcare assistants work varying amounts of overtime at varying rates, the system will also need to track what treatments are required to what patients
Draw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. Instructions • Identify the relationship between Entities (clearly showing the cardinality and participation)
Q1 Draw the F-R diagram , a collaboration class diagram and petri-net for the following requirements in a college library: there are two types of books: regular and reserved, and two types of users: students and faculty members. A student can check out a regular book for 1 month, while a faculty member can borrow one for 2 months. A late return for all users will incur a fine measured by the number of days, same for students and faculty. A reserved book can be checked out by any user for 4 hours. The fine for the later return is charged by number of hours. Any user who returned any books later than the deadline for more than twice will be levied an extra amount of money. A regular book checked out for more than 100 times will be put on sale. A reserved book checked out for more than 20 times will be put back as a regular book.
create an Enhanced Entity-Relationship (EER) diagram based on the provided information. Based on the following description, try creating the diagram using a tool such as draw.io, Lucidchart, or any other ER diagram tool: Entities: Person: person_ID (PK), name, address, birth date, phone number Subtypes: Employee, Physician, Patient, Volunteer Visit: date (PK, partial identifier), comments Care Centre: care_centre_ID (PK), name, location Laboratory: lab_ID (PK), name, location Bed: bed_number (PK), room_number, care_centre_ID (FK) Item: item_number (PK), description, unit_cost Treatment: treatment_ID (PK), treatment_number, treatment_name, treatment_date, treatment_time, results Relationships: Works_In (Person - Care Centre): Person (1, M) ----< Works_In >---- (1, M) Care Centre Assigned_To (Employee - Care Centre): Employee (1, M) ----< Assigned_To >---- (1, M) Care Centre Assigned_To (Physician - Care Centre): Physician (1, M)…
Draw an ER-Diagram for this situation and place minimum and maximum cardinalities on the diagram? Entity type: • EMPLOYEE with attribute: EmpID , Name (Firstname :besan, Lname) , Address :Amman, Birth_of_Date25/5/02 . • DEPARTMENT with attribute : DeptID , DeptName , Loc Relationship: Works_in Relationship between EMPLOYEE and DEPARTMENT and each employee is works in zero or many department and each department worked by one or many employee.
Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.
A. Draw a data model for the following entities, considering the entities as representing a system for a patient billing system and including only the attributes that would be appropriate for this context:  Patient (age, name, hobbies, blood type, occupation, insurance carrier, address, phone)  Insurance carrier (name, number of patients on plan, address, contact name, phone)  Doctor (specialty, provider identification number, golf handicap, age, phone, name)  Draw an entity relationship diagram (ERD) for the following situations: B.Consider for Cadinality (Crow's Foot Notation)• Whenever new patients are seen for the first time they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients can be signed up with only one carrier, but they must be signed up to be seen by the doctor. Each time a patient visits the doctor an insurance claim is sent to the carrier for…
Create an ER diagram for a reservation system of hotel rooms considering the following facts. You should indicate some attributes and the primary key for each entity. ■ Hotel contains several rooms Customer can reserve one or more rooms One room contains one, two, or three beds ⚫ Bed can be normal (for one person), double, or spare (less expensive)
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Business rules for hairdressers: 1. All entities should have surrogate primary keys. 2. Each hairdresser can work at multiple different salons over time, and every salon employs many different hairdressers. 3. The job title of a hairdresser at a specific salon must be stored in the database. 4. The name and surname of each hairdresser must be stored in the database. 5. The name of each salon must be stored in the database. 6. Every hairdresser is certified to have several different skills, and each skill can be mastered by many different hairdressers. 7. The name of each skill must be stored in the database. 8. The date that a specific hairdresser was certified to have a specific skill must be stored in the database.
Draw an Entity Relationship Diagram for all of those below. Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored. An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production. Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall. Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books. Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for…
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Tip: Pay attention to the mark allocation shown below. Sheep farm feed supplier business rules: • All entities must have surrogate primary keys. • A contact person represents one or more suppliers, and each supplier has exactly one contact person. • A supplier supplies many feed products, and every feed product can be supplied by many suppliers. • Each feed product belongs to a specific feed type, and many feed products can have the same feed type.
draw an er diagram with rhe informtion provided. Entities: Beach Coffee Carts Coffee Shops Products (Iced coffee, flavors, creamers, breakfast items, etc.) Sales Supplies Warehouse Employees Attributes could include: For Beach Coffee Carts and Coffee Shops: Location, Street, Shop Name, etc. For Products: Product ID, Name, Type, Price, etc. For Sales: Transaction ID, Date and Time, Product(s) Sold, Quantity, Employee ID, etc. For Supplies: Supply ID, Name, Quantity, Location, Supplier, etc. For Warehouse: Warehouse ID, Location, Storage capacity, etc. For Employees: Employee ID, Name, Role, Sales Performance, etc. Relationships Beach Coffee Carts and Coffee Shops have a "Location" relationship with Sales. Products are sold in Sales transactions. Supplies are stored in the Warehouse. Employees have a "Role" relationship with the type of work they do. Employees are associated with Sales transactions