You are to design a Hospital database. So before creating the database, your task is to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are to design a Hospital database. So before creating the database, your task is to design the ER diagram based on the following data requirements: a. The hospital has departments. Each department has a name, department ID, location. Location consists of floor number and wing number (which will contain the values North, South, East or West). b. Doctors work for the department. Doctors have license number, name, title, multiple specializations. Some doctors supervise other doctors. c. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. Patients take appointments from doctors. Appointment date and time is recorded. d. e. A patient may have an attendant. An attendant will have his/her name and relationship with the patient as a record in the database. The hospital allows I attendant with each patient. Write down any assumptions you may have made. Question 3 Given the scenario below, construct an EER diagram for the library management system at Sir Fazle Hasan Abed University: a. Members have a unique ID, name, joining date, phone number and an email address. b. Members have to be either a faculty member or student or they can be both. Students have a CGPA attribute, faculty members have a courses taught attribute. Faculty members may have taught several courses and a course is composed of course code and title. c. d. Each book has several Book Copies. The copy number, date purchased and shelf number is stored. Note that for each book the copy numbers are 1, 2 and so on. Shelf number and date purchased can be the same for different books. e. Members can borrow book copies. The borrowed date, return date, due date and late fees are recorded. The late fees can be calculated using the return date and due date, so it should not be stored, but shown using an appropriate symbol. Books have a unique ISBN, title, multiple authors, publisher, publication date, edition. A book can be a sequel to another book. You are to design a Hospital database. So before creating the database, your task is to design the ER diagram based on the following data requirements: a. The hospital has departments. Each department has a name, department ID, location. Location consists of floor number and wing number (which will contain the values North, South, East or West). b. Doctors work for the department. Doctors have license number, name, title, multiple specializations. Some doctors supervise other doctors. c. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. Patients take appointments from doctors. Appointment date and time is recorded. d. e. A patient may have an attendant. An attendant will have his/her name and relationship with the patient as a record in the database. The hospital allows I attendant with each patient. Write down any assumptions you may have made. Question 3 Given the scenario below, construct an EER diagram for the library management system at Sir Fazle Hasan Abed University: a. Members have a unique ID, name, joining date, phone number and an email address. b. Members have to be either a faculty member or student or they can be both. Students have a CGPA attribute, faculty members have a courses taught attribute. Faculty members may have taught several courses and a course is composed of course code and title. c. d. Each book has several Book Copies. The copy number, date purchased and shelf number is stored. Note that for each book the copy numbers are 1, 2 and so on. Shelf number and date purchased can be the same for different books. e. Members can borrow book copies. The borrowed date, return date, due date and late fees are recorded. The late fees can be calculated using the return date and due date, so it should not be stored, but shown using an appropriate symbol. Books have a unique ISBN, title, multiple authors, publisher, publication date, edition. A book can be a sequel to another book.
Expert Answer:
Answer rating: 100% (QA)
ER diagram of hospital database Entities Department departmentid name location floornumber wingnumber Doctor licensenumber name title specializations multiple supervisorlicensenumber optional Patient ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these programming questions
-
You have a savings goal of $122,130. If you plan to invest $15,000 each year for 7 years, what rate of interest must you earn in order to meet your goal? Show the formula and all work.
-
There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
In December 2022, more than a year after Ontarios vaccine management system was breached, the Ontario government is notifying around 360,000 people that their data was stolen and potentially given to...
-
An S-590 iron component (Figure 8.33) must have a creep rupture lifetime of at least 20 days at 650C (923 K). Compute the maximum allowable stress level?
-
Suppose a Waldorf store in Atlanta, Georgia, ended November 2010 with 900,000 units of merchandise that cost an average of $5 each. Suppose the store then sold 800,000 units for $4.8 million during...
-
Popular books such as The God Delusion (Dawkins, 2008) and God Is Not Great: How Religion Poisons Everything (Hitchens, 2007) make a strong case against religion. But religion plays an important role...
-
Mayberry Manufacturing Inc. has two departments, Mixing and Blending. When goods are completed in Mixing, they are transferred to Blending and then to the finished goods storeroom. There was no...
-
Problem 7. Consider the n-qubit GHZ state, |GHZ) and the n-qubit W state, (W), given by |GHZ) = 1 |W) = 1 2 (10) n + 1) on), (|10...0) + |01...0). 0) + |01...0)... + 100...1)). Compute the reduced...
-
Donna Shader, manager of the Winter Park Hotel, is considering how to restructure the front desk to reach an optimum level of staff efficiency and guest service. At present, the hotel has five clerks...
-
Assuming constant costs in the neighborhood of their current levels of production, the exhibit shows the number of tires each country would have to forgo in order to produce the additional radios...
-
Since 1982, Denmark has pegged the exchange rate for the crown against first the German mark and later against the euro. In recent weeks the fixed exchange-rate regime has come under strain as the...
-
The San Franciscobased visual social media firm Pinterest is one of the first Silicon Valley companies that recognized the dismal state of diversity in the technology industry. In fact, a former...
-
HR systems are designed to give employers a competitive advantage by focusing on how to attract and hire the best talent, as well as how to develop, train, and retain employees. This includes...
-
What do Rolls-Royce, Walmart, Royal Dutch Shell, and SAP have in common? These companies and others have faced investigations of corruption and bribing government officials to facilitate winning...
-
After you have studied Economics in the News on pp. 234235, answer the following questions. a. What are the U.S. trade balances with Mexico and Canada and how have those balances changed since 2000?...
-
ABC Corporation is experiencing difficulty in paying its bills and is considering filing for bankruptcy. Current data show: Assets Cash Accounts Receivable Inventory - Materials Inventory - Finished...
-
Use the T account for Cash below to record the portion of each of the following transactions, if any that affect cash. How do these transactions affect the companys liquidity? Jan. 2 Provided...
-
Modify Figure 2-11a to model the following additional information requirements: The training director decides for each employee who completes each class who (what employees) should be notified of the...
-
Explain how physical database design has an important role in forming a foundation for regulatory compliance.
-
Explain the two common forms of encryption.
-
A drainage ditch is to be built to carry runoff from a subdivision. The maximum design capacity is to be $1 \mathrm{million} \mathrm{gph}(\mathrm{gal} / \mathrm{h})$ and it is to be concrete lined....
-
An open drainage canal with a rectangular cross section is $3 \mathrm{~m}$ wide and $1.5 \mathrm{~m}$ deep. If the canal slopes $950 \mathrm{~mm}$ in $1 \mathrm{~km}$ of length, what is the maximum...
-
An open drainage canal is to be constructed to carry water at a maximum rate of $10^{6} \mathrm{gpm}$. The canal is concrete lined and has a rectangular cross section, with a width that is twice its...
Study smarter with the SolutionInn App