.... ->Assig..System Analysis And DatabasesDhafer Sabah Yaseen1. Create user (hms) with all required privilegesThen Using Below ERD Design System as Belowhms employeehms doctorsPKa Employee_ID: varchar(255)O Name : varchar(255)hms patientsPKe Batch_No : varchar(255) PKPatient_ID : varchar(255)O Name : varchar(255)& Employee_ID : varchar(255)FKe Address : varchar(255)e Address : varchar(255)O DOB : dateO DOB : datehms attended_bye Contact : varchar(25)e Gender : varchar(10)e Contact : varchar(25)FK* Patient_ID : varchar(255)e Batch_No : varchar(255) FKe Gender : varchar(10)# Salary: float(15,3)e Blood_Group : varchar(5)O DOA : datee Category : varchar(25)FK O Dept_No : varchar(255)hms departmentse Name : varchar(255)a Location : varchar(255)e Dept_No : varchar(255) PK2- Create all tables with all constraint.Note:The sequence of creating table and constraints very important .3- implement DML commands as belowA. Insert 10 records to patients table with appropriate values.B. Update employee salary to 1800 for all employee in department number40 in employee table.C. Delete the record from table (attended_by) for the patient_ID = P7.D. Use TCL Transaction Control Language ( Commit , Savepoint, Rollback)after or before implement and run the DML commands in ( A, B and C)GOOD LUCK

Hospital needs a proper management system to coordinate their employees, communicate with doctors,…

hms doctors PK Employee_ID : varchar(255) O Name : varchar(255) hms patients PK e Batch_No : varchar(255) PK Patient_ID: varchar(255) e Name : varchar(255) e Employee_ID: varchar(255) FK e Address : varchar(255) e Address : varchar(255) O DOB : date hms attended_by O DOB : date e Contact : varchar(25) e Contact : varchar(25) FK a Patient_ID: varchar(255) e Batch_No : varchar(255) FK a DOA : date e Gender : varchar(10) e Gender : varchar(10) # Salary : float(15,3) e Blood_Group: varchar(5) e Category : varchar(25) hms departments FK e Dept No : varchar(255) e Name : varchar(255) e Location : varchar(255)

hms doctors PK Employee_ID : varchar(255) O Name : varchar(255) hms patients PK e Batch_No : varchar(255) PK Patient_ID: varchar(255) e Name : varchar(255) e Employee_ID: varchar(255) FK e Address : varchar(255) e Address : varchar(255) O DOB : date hms attended_by O DOB : date e Contact : varchar(25) e Contact : varchar(25) FK a Patient_ID: varchar(255) e Batch_No : varchar(255) FK a DOA : date e Gender : varchar(10) e Gender : varchar(10) # Salary : float(15,3) e Blood_Group: varchar(5) e Category : varchar(25) hms departments FK e Dept No : varchar(255) e Name : varchar(255) e Location : varchar(255)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

.......................................................................
State Kepler's third law.
2. RADIOACTIVE DECAY, REVISITED This is a modified version of chapter 1 problem 4 in your textbook. Consider the radioactive decay of nuclei A into nuclei B, which can then also decay. The numbers of each species as a function of time are given by N₁ (t) and NB (t), and the decay of each species is governed by¹: dNA dt == NA dNB NA NB = dt ΤΑ TB where T and T are the decay time constants for each type of nucleus.
71 Use the Boolean algebra to: a. Prove that: x (x. y) + x (x +y) + (x. y)) = x ỹ %3D b. Solve the expression: F(x,y,z) = xy Z + xyz+xy z %3D c. Solve the expression: F(A, B, C) = A BC+ABC+AB C+A BC
3. An unnamed faculty uses three screens on his desk. One measures 1920 x 1080 pixels and the other two measure 1280 x 1024 pixels. a. Create variables for height and width (in pixels) for each of these displays and set these variables equal to their respective measures. b. Determine the total number of pixels across the three displays. This numerical answer should be represented by a variable. c. If each pixel were to draw 1.2e-5 watts, create a variable for this value and determine the wattage required to activate all the pixels across all three screens at once. This numerical answer should be represented by a variable.
Fill in the blanks with the correct choice to complete the se 1- He always .…....…... about trivial things. A. Lies B. Lied C. Lying 2- 1 hope everything is........ Fine tomorrow. A. Will be B. Going to be C. Being 3- She was walking alone When the child.......... to cry. A. Begin B. Began C. begun
1. Sit down here. * don't didn't doesn't 2. There is plenty of milk in the bottle. aren't wasn't isn't 3. She has to leave early. * doesn't have don't have didn't have 3. Study hard. You will fail. * but and or 4. He arrived late. He missed the train.* so and 5. Father went to the dentist. His tooth hurt. * or for but
i need the answer quickly
I need the answer quickly
I need the answer as soon as possible
1. Alcohol dissolved in water is an example of a solution. a. solid in liquid b. liquid in liquid c. gas in liquid d. liquid in gas