Database Systems: Design Implementation & Management
11th Edition
ISBN: 9781305850378
Author: Coronel
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 2P
Explanation of Solution
Crow’s Foot ER diagram for Tiny Hospital:
The following data model shows the solution for the given question:
Explanation:
- In the above data model, “Room” and “Patient” are the entities. Here a specialization hierarchy is not taken...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Question 3
Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram)
Scenario
The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…
Create an ER model for a restaurant. The specifications are as follows:
The customer has an id, name, address and telephone number. The customer can
reserve a table before arrival. Each reservation has a unique key and includes the date
and time of reservation and the number of seats. Upon arrival, the customer places an
order. Each order has a unique order number and includes one or more food items.
Each food item is distinguished by an id and has name and price. We also keep track
of the cashier who settle the payment with the customer before he leaves the
restaurant. The cashier has an id and name.
Each publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERD
Chapter 5 Solutions
Database Systems: Design Implementation & Management
Ch. 5 - Prob. 1RQCh. 5 - What kinds of data would you store in an entity...Ch. 5 - Prob. 3RQCh. 5 - What is a subtype discriminator? Give an example...Ch. 5 - Prob. 5RQCh. 5 - What is the difference between partial...Ch. 5 - Prob. 7RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 9RQCh. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 16RQCh. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8CCh. 5 - Prob. 9CCh. 5 - Prob. 10C
Knowledge Booster
Similar questions
- Please draw an ER diagram of the informations provided.arrow_forwardshould use Lucidchart to draw the ERD.arrow_forwardPlease create a class diagram for a local car rental company. In this database, customers are tracked by their driver's license number. This database also records a customer’s first name, last name, and date of birth.Cars are tracked by the VIN. This database also records a car’s brand, model, and daily rental price.A customer can rent different cars, and a car can be rented by different customers. All rental details are stored in the rental history. Each rental history has a rental ID, rental start date, and satisfaction rating (on a 1-10 scale).All cars will be Tested after it is returned to the store. A car may be examined by a different employee each time when it is returned; one employee examines multiple cars every day. All examination details are stored in the log. Each log has a log ID and records the examination time.Your database tracks an employee by the employee ID and records the employee’s first name and last name.arrow_forward
- Please draw an ER diagram of the informations provided.arrow_forwardComplete the ERD below by dragging the ends of crows feet and the specialization hierarchy symbols to their correct location. The XYZ Company has a motor pool and wants to track scheduled and unscheduled maintenance to each of the vehicles in its fleet. Each vehicle is assigned a unique unit number that will be used on all paperwork and is displayed on the vehicle. In addition to the unit number all vehicles have a unique Vehicle Identification Number (VIN) that is a long and complex string of letters and numbers, and all vehicles belong to one of three types "T" for trucks, "R" for trailers, and "A" for automobiles. For trucks, we need to know the Gross Vehicle Weight (GVW) and the type of trailer hitch (if it has one). For trailers, we need to know their length, the maximum weight allowed, the type of trailer (Van, Reefer, Low Boy, Flat…), and the required hitch type. For automobiles, we need to know how many adults it will seat, its color, and if it is a "4 wheel drive". Maintenance…arrow_forwardComplete the ERD below by dragging the ends of crows feet and the specialization hierarchy symbols to their correct location. The XYZ Company has a motor pool and wants to track scheduled and unscheduled maintenance to each of the vehicles in its fleet. Each vehicle is assigned a unique unit number that will be used on all paperwork and is displayed on the vehicle. In addition to the unit number all vehicles have a unique Vehicle Identification Number (VIN) that is a long and complex string of letters and numbers, and all vehicles belong to one of three types "T" for trucks, "R" for trailers, and "A" for automobiles. For trucks, we need to know the Gross Vehicle Weight (GVW) and the type of trailer hitch (if it has one). For trailers, we need to know their length, the maximum weight allowed, the type of trailer (Van, Reefer, Low Boy, Flat…), and the required hitch type. For automobiles, we need to know how many adults it will seat, its color, and if it is a "4 wheel drive". Maintenance…arrow_forward
- Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a…arrow_forwardOverview: A new bank wants to make a simple application to keep track of all accounts and transactions. In this TMA, it is required to help the bank manager implement the required application. Requirements: After a quick meeting with the bank manager, you got the following information: It is required to store all bank accounts in one collection and all the transactions happened in another collection. Each account has a unique account number, a holder and balance. There is a specific prefix (common for all accounts) that should be added to the holder's civil id to create the unique account number. In addition, it is not allowed for a holder to have more than one account. Furthermore, only three transactions are allowed on any account: deposit, withdrawal and transfer money to another account. Each holder has a unique civil ID (national id), a name and other attributes (add at least 2 attributes from your choice). For each transaction, it is required to store the account(s) affected,…arrow_forwardEach 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.arrow_forward
- A variable's description must include not only its name, but also its "type" and "additional attributes." Every variable has more than one type of data. If you can describe the idea, we'll be able to describe any number better in the future.arrow_forwardBelow is “Book Order,” the only table in library management system’s database. The design of “Book Order” as you may tell is in the zero normal formal form, you as the database designer want to convert the design into the third normal form. Order ID Special order date Customer ID Customer last name Customer First name Customer birth date Book ISBN1 Book Title 1 Book Author 1 Book publication year 1 Book ISBN2 Book Title 2 Book Author 2 Book publication year 2 Store ID Store name Store location Special order status Book Order(Order ID, Special order date, Customer ID, Customer last name, Customer First name, Customer birth date, Book ISBN1, Book Title 1, Book Author 1, Book publication year 1, Book ISBN2, Book Title 2, Book Author 2, Book publication year 2, Store ID, Store name, Store location, Special order status)arrow_forwardOpen your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage