Write queries to create database and tables and constraints based on ER Diagram. date admitted date discharged
Fantastic news! We've Found the answer you've been seeking!
Question:
Write queries to create database and tables and constraints based on ER Diagram.
Transcribed Image Text:
date admitted date discharged name address P details Contact No trainee E-R DIAGRAM FOR HOSPITAL MANAGEMENT SYSTEM PID Patient Attends Doctor ISA Permanent Treatment Visiting Bill Assigned Rooms ID Period Price Medicine Room type Rooms ISA Receptionist Maintains appointment Quantity EID Contact No patient ID Record Code Governs Nurse Salary Employee History description E address Sex record no NID Ename date admitted date discharged name address P details Contact No trainee E-R DIAGRAM FOR HOSPITAL MANAGEMENT SYSTEM PID Patient Attends Doctor ISA Permanent Treatment Visiting Bill Assigned Rooms ID Period Price Medicine Room type Rooms ISA Receptionist Maintains appointment Quantity EID Contact No patient ID Record Code Governs Nurse Salary Employee History description E address Sex record no NID Ename
Expert Answer:
Answer rating: 100% (QA)
ANSWER To create a database and tables based on the ER diagram for a hospital management system we can use the following SQL queries CREATE DATABASE hospitalmanagementsystem USE hospitalmanagementsyst... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these databases questions
-
Moran owns a building he bought during year 0 for $212,000. He sold the building in year 6. During the time he held the building, he depreciated it by $32,250. What are the amount and character of...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
A hospital department wants to build a database to record and manage the information of its staff and patient. Following the analysis of the requirements, the following observations were made: Every...
-
EX: let X ~ B (5, 0.4) X ~ B (7, 004) Xz ~ B ( 7 0.2) Find the dist. of Now Noint cik Date. 2 No. R X) q X + X 3 X + X
-
Use absolute value notation to define the interval (or pair of intervals) on the real number line. 1. 2. 3. 4. 5. All real numbers at least three units from 7 6. All real numbers more than five units...
-
In setting up a pay structure, what legal requirements must an organization meet? Which of these do you think would be most challenging for a small start-up business? Why?
-
How can management assure that all shipped goods are billed?
-
At December 31, 2013, Dustin Company reported this information on its balance sheet. Accounts receivable............ $960,000 Less: Allowance for doubtful accounts.... 78,000 During 2014, the company...
-
3. Dollar General has a sale on a 12 pack of 12 ounce cans of Pepsi. Buy three for $11 and get a digital coupon for $2 off. It is also offering a sale on a 6 pack of 16.9 ounce bottles. Get four 6...
-
Jeffrey Helm owns a health and fitness center called Bulk- Up in Harrisburg. He is considering adding more floor space to meet increasing demand. He will either add no floor space ( N), a moderate...
-
During 2019, Peter rented his vacation home for 90 days and spent 30 days. Gross rental income from the property was $15,000. Peter incurred the following expense: Mortgage and Real Estate taxes 9000...
-
Imagine that the spouse of a coworker recently died from an infectious disease. Write the coworker a letter of sympathy.
-
Unfortunately, we cannot contribute to your worthy charitable cause this year. At present we need all the funds of our organization to lease new equipment and offices for our new branch in...
-
Microtargeting is a controversial persuasive technique. Advertisers are trying to sweet-talk Internet users into allowing them to harvest their location information, browser history, and other...
-
The following message responds to the inquiry in Activity 6.2. Dr. Woo asks for information about dealing with a data breach at his medical office. Mr. Gallagher, representing Safe Cybernetics, wants...
-
Naomi Emery, a hardworking auto damage adjuster, has sent an e-mail request asking that her employer create a program to reimburse the tuition and book expenses for employees taking college courses....
-
Elton Weiss and Reyna Herrera-Weiss are married and report the following income items: Elton's salary $ 254,000 50,000 Reyna's Schedule C net profit The income tax deduction for Reyna's SE tax was...
-
Write the expression in radical notation. Then evaluate the expression when the result is an integer. 23 -1/2
-
Some individuals argue that accountants should focus on producing financial statements and leave the design and production of managerial reports to information systems specialists. What are the...
-
Develop a set of tables to implement the integrated REA diagram you developed in Problem 18.1 for Joes ice-cream shop in a relational database. Specify a primary key for each table, and suggest at...
-
Stans Southern Barbeque Supply Store orders mass-produced barbecue products from various suppliers. Stans maintains information about a contact person at each supplier along with all required address...
-
Using Program12.m, find the first five natural frequencies of a thin fixed-fixed beam. Data From Example 8.4:- Find the natural frequencies of a bar with one end fixed and a mass attached at the...
-
Using Program \(12 . \mathrm{m}\), solve Example 8.4. Data From Example 8.4:- Find the natural frequencies of a bar with one end fixed and a mass attached at the other end, as in Fig. 8.9.
-
Using MATLAB, plot the dynamic response of the plucked string, Eq. (E.6) of Example 8.1, at \(x=l / 2\). Data: \(h=0.1 \mathrm{~m}, l=1.0 \mathrm{~m}, c=100 \mathrm{~m} / \mathrm{s}\). Data From...
Study smarter with the SolutionInn App