Consider the relational schema that you created for Hospital Management System. Create Data Definition Language (DDL)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the relational schema that you created for Hospital Management System. Create Data Definition Language (DDL) to create the following tables. Note that Primary Key and Foreign Key constraints should be included in your SQL. However, Not Null constraint can be ignored. Regarding to the data type, you can use one of the following data types ONLY: VARCHAR2(n), CHAR(n), DATE and NUMBER(n). (i) Creating "DEPARTMENT" table (ii) Creating "DOCTOR" table phone number Salary first time check up Specialties Doctor name date of admitted TD Number phone number room number location work Patient number address Admitted name Hospital Management System. patients. condition Department age name Regular date of visit facilities (prescription) type operation payment Condition date Doctor ID name Operations DID Salary phone drame Pnum Patients Phone num name age phone address CDID Regular Patients Phone num Departments name type cond location Admitted - Patients Phonenum |date | visit date prescription payment room facility da Cond Doctor special DID Speciality Consider the relational schema that you created for Hospital Management System. Create Data Definition Language (DDL) to create the following tables. Note that Primary Key and Foreign Key constraints should be included in your SQL. However, Not Null constraint can be ignored. Regarding to the data type, you can use one of the following data types ONLY: VARCHAR2(n), CHAR(n), DATE and NUMBER(n). (i) Creating "DEPARTMENT" table (ii) Creating "DOCTOR" table phone number Salary first time check up Specialties Doctor name date of admitted TD Number phone number room number location work Patient number address Admitted name Hospital Management System. patients. condition Department age name Regular date of visit facilities (prescription) type operation payment Condition date Doctor ID name Operations DID Salary phone drame Pnum Patients Phone num name age phone address CDID Regular Patients Phone num Departments name type cond location Admitted - Patients Phonenum |date | visit date prescription payment room facility da Cond Doctor special DID Speciality
Expert Answer:
Answer rating: 100% (QA)
Heres an example of using Data Definition Language DDL to create the DEPARTMENT table for a hospital ... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
How do ethical considerations surrounding corporate responsibility, stakeholder stewardship, and societal welfare intersect with the exigencies of bankruptcy law and financial restructuring...
-
Create data types for attributes. Remember that your COURSE_ID should be alphanumeric or VARCHAR (not numeric). You must use primary and foreign keys in your Data Definition Language (DDL) to create...
-
Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...
-
In practice, bar charts are used occasionally to summarize a numerical variable over time, which can be handy. The bar chart below shows the inflation rate based on the Consumer Price Index in India....
-
A clock at rest has a rectangular shape, with a width of 24 cm and a height of 12 cm. When this clock moves parallel to its width with a certain speed v its width and height are the same. Relative to...
-
Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are used in a circus act in which two clowns serve as human cannonballs. The clowns are fired toward each other...
-
Persistent Earnings Identify each of the following items as either (P) persistent, or (T) transitory. a. Sale of merchandise. b. Settlement of a lawsuit. c. Interest income. d. Payment to vendors. e....
-
Consider the following situations: a. Business receives $3,800 on January 1 for 10-month service contract for the period January 1 through October 31. b. Total salaries for all employees is $3,200...
-
You plan to apply for a loan from Bank of America. The nominal annual interest rate for this loan is 7.67 percent, compounded daily (with a 365 day year). What is the effective annual rate, or EAR...
-
A division of your company purchased a large quantity of new desktop computers during the current fiscal year. An internal audit manager has asked you to audit the process used to acquire the...
-
A terrorist was able to purchase an airplane ticket in another country and land in the US, What does this incident tell you of general screening precautions and realistic explosive detection methods...
-
ABC Companys budgeted sales for June, July, and August are 1 4 , 6 0 0 , 1 8 , 6 0 0 , and 1 6 , 6 0 0 units respectively. The selling price for each unit is $ 1 2 . Based on past experience, ABC...
-
Consider this formula. z = y |* If z = 4.0 and y = 8.8, what is the value of x? Express your answer to the tenths place (i.e., one digit after the decimal point).
-
Solve 35 9 11. Round to the nearest thousandth as needed.
-
If (log 1068)/(log108) = logganswer, then what is the answer?
-
Pina Colada Corporation manufactures car stereos. It is a division of Berna Motors, which manufactures vehicles. Pina Colada sells car stereos to Berna, as well as to other vehicle manufacturers and...
-
ABC is a new company and won't be paying dividend for the next five years. In year 6 it will pay a $3 dividend, then a $5 dividend and a $7 dividend year 8. Afterwards dividend will slow to 2%...
-
QUESTION 2 The CEO of Farisha Hijab Sdn Bhd insisted on further investigation to be carried out that he also required Mr Muaz to conduct the analysis of variance for the material and labour of the...
-
In categorization, what is meant by the property of selective type inheritance?
-
This exercise refers to the relations R1 and R2 given below. Show the relations created as a result of the following relational algebra operations Relation R1 Rl.a R1.b R1.c 30 a 20 45 b 32 75 a 24...
-
Consider the Presentation Layer ER diagram that appears in Figure 4.21. a. What makes SCHOOL part of the specialization lattice involving SCHOOL, NOT_FOR_PROFIT_ORGANIZATION, and PUBLIC_SCHOOL, and,...
-
You are auditing the financial statements of Aardvark Wholesalers, Inc. (AW), a wholesaler with operations in 12 western states and total revenues of about $125 mil lion. You are carrying out an...
-
Which type of audit involves a review of general and application controls, with a focus on determining if there is compliance with policies and adequate safe guarding of assets? a. information...
-
Robinsons Plastic Pipe Corporation uses a computerized inventory data processing system. The basic input record to this system has the format shown in Table 9-8. You are performing an audit of source...
Study smarter with the SolutionInn App