
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
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 MEDICATION
b. Create a Crow's Foot ERD that depicts a relational
Expert Solution

Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 1 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
Consider the following relations in the relational schema for a database that keeps track of business trips of Sales Representatives in a sales office:
salesperson(SSN, lName, startYear, deptNo)
trip(tripID, SSN, fromCity, toCity, departureDate, returnDate)
expense(tripID, accountNumber, amount)
Part 1
Answer the Following 3 Questions. Places Your Answers in a Word Processor
identify the primary key for each table.
Identify the foreign keys in each table.
Given the above foreign keys, list the order in which the tables could be successfully created.
Write your Answers using a Word Processor
Review the Relational Schema and other necessary material in this assignment to create the metadata document for the above relational schema.
Write your Metadata using a Spreadsheet or a Word Processor. Submit the Final Version as a PDF
Open up a text editor such as Visual Studio Code.
Write the SQL SELECT Queries to respond to the following Information Requests
Find…
arrow_forward
Imagine you have been tasked with cataloging the information found in books. Either more books need to be added, or the ones on one side of the shelf need to be rotated out. Find the optimal data structure and explain why it works here. Add books to the shelf in a dynamic fashion. When new information must be added to an existing database but there isn't enough space, what happens?
arrow_forward
Give a relational database schema for the following:
EMPLOYEE (Fname, Minit, Lname, SSN, Bdate, Address, Sex, Salary, Super_ssn, Dno)
PK= Ssn
FK= Super_ssn
DEPARTMENT ( Dnamc, Dnumbcr, Mgr_ssn, Mgr_start_datc)
PK= Dnumbcr
FK= Dno
DEPT_LOCATIONS (Dnumber, Dlocation)
PK= Dnumber
FK= Dnumbcr
PROJECT (Pname, Pnumber, Plocation, Dnum)
PK= Pnumber
FK= Pno
WORKS_ON (Essn, Pno, Hours)
PK= Pno
FK= ssn
DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship)
PK= Essn
FK= Ssn
arrow_forward
Consider a database system for a Wholesale Management System. The data requirements are summarized as follows:
o Maintain the details of stock like their id, name, quantity.
o Maintain the details of buyers from which manager must buy the stock like buyer id, name, address, stock id to be bought.
o Details of customers i.e. name, address, id.
o Defaulters list of customers who have not paid their pending amount after the due date So List of payment paid or pending.
o The stock that is to buy if quantity goes less than a particular amount.
o Profit calculation for a month.
o Quantity cannot be sold to a customer if the required amount is not present in stock and date of delivery should be maintained up to which stock can be provided.
SQL Queries:
1. List of payment paid or pending customers.
2. Find the Defaulters list of customers who have not paid their pending amount.
3. Find the details of customers name, address, id.
4. Find Query to get information of employee where employee is…
arrow_forward
19.
A multidimensional database model is used most often in which of the following models?
a.
Data warehouse
b.
Relational
c.
Hierarchical
d.
Network
arrow_forward
Using Crow’s foot notation, draw an ER diagram of the conceptual schema for another part of a University database, described as follows:
You must show connectivity, cardinality, participation and relationships strength.
Academic staff, general staff and students are the only persons at the university.
Each person is either an academic staff, or a general staff, or a student.
A person is uniquely identified by a PerId (person's ID), and has a Name and an Address. An Address is composed of HouseNo, Street, and City.
A characteristic property of a student is that she/he has at least one Major and one NoOfPts (number of points) for each major.
An academic staff has a Position and an AcQual (academic qualification).
A general staff has a GenPos (general position).
An academic staff teaches at most one course, whereas a student takes at least one course.
A course is uniquely identified by a CourId (course ID), and has a CourName (course name).
Each course is taught by at least one academic…
arrow_forward
Relational Database Schema for Case StudyThe relational database schema for Hospital Management database is as follows:1. DEPARTMENT (D_NAME, D_LOCATION, FACILITIES)2. ALL_DOCTORS (DOC_NO, DEPARTMENT)3. DOC_REG(DOC_NO, D_NAME, QUALIFICATION, SALARY, EN_TIME, EX_TIME, ADDRESS,PH_NO, DOJ)4. DOC_ON_CALL (DOC_NO, D_NAME, QUALIFICATION, FS_PR_CL, PYMT_DU, ADDRESS,PH_NO)5. PAT_ENTRY (PAT_NO, PAT_NAME, CHKUP_DT, PT_AGE, SEX, RFRG_CSTNT, DIAGNOSIS,RFD, ADDRESS, CITY, PH_NO, DEPARTMENT)6. PAT_CHKUP (PAT_NO, DOC_NO, DIAGNOSIS, STATUS, TREATMENT)7. PAT_ADMIT (PAT_NO, ADV_PYMT, MODE_PYMT, ROOM_NO, DEPTNAME, ADMTD_ON,COND_ON, INVSTGTN_DN, TRMT_SDT, ATTDNT_NM)8. PAT_DIS (PAT_NO, TR_ADVS, TR_GVN, MEDICINES, PYMT_GV, DIS_ON)9. PAT_REG (PAT_NO, DATE_VIS, CONDITION, TREATMENT, MEDICINES, DOC_NO, PAYMT)10. PAT_OPR (PAT_NO, DATE_OPR, IN_COND, AFOP_COND, TY_OPERATION, MEDICINES,DOC_NO, OPTH_NO, OTHER_SUG)11. ROOM_DETAILS (ROOM_NO, TYPE, STATUS, RM_DL_CRG, OTHER_CRG)
arrow_forward
Consider a database of King Abdulaziz Airport. For this mini-world example, define four mini-world entities and four mini-world relationships.
arrow_forward
A relational database can't have relationships like this, as shown by the examples given?
arrow_forward
Suppose that you have been tasked with cataloging the information found in books. Either more books need to be added, or the ones now stacked on one side of the shelf need to be rotated. Find the optimal data structure and explain why it works here. Provide a flexible method of stocking the bookcase. What happens, meanwhile, if fresh information must be added to a database but there isn't enough space for it?
arrow_forward
This test concerns database design, including both the logical design via the Entity Relationship (E - R) model and the physical model via relational database tables. The subject of the model is the registration of students in college classes, and there may be multiple classes for each course. The college model should include: courses (for example the CBU catalog), the current classes (or course-sections) given for courses (for example the CBU schedule for a term), the faculty qualified to teach courses, the scheduling of classes (to buildings/rooms, times, and faculty members), the assignment of faculty to students for advising (1 advisor per student), and the scheduling of students to classes.For unique identifiers you can use the following abbreviations:SID Student IDCID Course ID (ie MIS 471, …)SEC Course Section (ie A, B, C, …)BID Building ID (ie BU, BH, K, …)RID Room NumberFID Faculty IDTID Timeslot ID (ie TR 9:30, MWF 8am, …)CRN Course Record Number (an auto key for each…
arrow_forward
Database System
In database management, which of the following is a design case that occurs only when there is an improper relationship or represented in a non-consistent way?
Choose an answer
A Implementing Relationships
B Redundant Relationships
C Fan Traps
D Maintaining time variant data
arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education