Q)1. Create user (hms) with all required privileges.Then Using Below ERD Design System as Belowhms employeehms doctorsPKe Employee_ID: varchar(255)hms patientsPKPatient_ID : varchar(255)e Batch_No: varchar(255) PKe Name : varchar(255)a Name : varchar(255)& Employee_ID : varchar(255)FKe Address : varchar(255)e Address : varchar(255)O DOB : dateO DOB : datehms attended_byeContact : varchar(25)e Contact : varchar(25)FKPatient ID: varchar(255)e Gender : varchar(10)e Gender : varchar(10)e Batch_No : varchar(255) FK# Salary : float(15,3)eCategory : varchar(25)FK e Dept_No : varchar(255)e Blood_Group : varchar(5)O DOA : datehms departmentse Name : varchar(255)e Location : varchar(255)Dept No: varchar(255) PK2- Create all tables with all constraint.

CREATE TABLE EMPLOYEE ( EMPLOYEE_ID VARCHAR(255),…

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

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

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

See similar textbooks

Similar questions

8. In the following code below, the code selects an Employee object by primary key. However you are missing the line of code to create the employee variable. What line of code are you missing? [HttpGet] public IActionResult Edit(int id) { ViewBag.Action = "Edit"; ViewBag.Departments = context.Departments.OrderBy(d => d.DepartmentName).ToList(); ________________________________________________ return View(employee); } 1. var employee = id 2. var employee ="select * from Employee where Id = id"; 3. var employee = context.Employees.Find(id); 4. context.Employees.Find(id) = employee;
7. Create a private synonym that enables you to reference the MY_FIRST_SEQ object asNUMGEN.
Please help to write to these triggers in Postgresql: You should create a trigger, called price change, that adjusts the reserver routes with pending payment. I assume you have ticketed and reserver routes when the cost per mile of a train is change. (Table Ticket and Table Reservation)
Q1. Write a reference, in VBA code, to each of the following ranges. (You can assume that each of these ranges is in the active worksheet of the active workbook, so that you don’t have to qualify the references by worksheet or workbook.) Here’s an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (“A1”).Offset(2,1) The fifth cell of the range B1:B30. The cell at the intersection of the 25th row and 5th column of the range A1:Z100. The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange. The entire column corresponding to cell C5. A range of employee names, assuming the first is in cell B2 and they extend down column B (although you don’t know how many there are). Q2. Write a VBA program (consisting of a single subroutine) to check existence of a given value in a list. Specifically, you are given a list of product IDs in column A, as follows: You don’t know…
Create table Medicine (MInventory_Id int primary key, M_Name varchar (40), Manufacturer varchar (40), Price varchar (20), Quantity int, Exp_Date date); Create table PrescriptionMedicine (Prescription_Id int primary key, MInventory_Id int); Example of a table (Medicine) Insert into Medicine values(101, ‘Biaxin’, ‘Pfizers’, ‘$10.99’, 1, 10/5/02); Insert into Medicine
Create a schema user which will be application owner (in other words schema owner) User name: <YourName>_dba Profile: DEFAULT Password: Oracle1234 Default Tablespace: DBA625TS Assign default tablespace Quota: unlimited Temporary Tablespace: TEMP
Write a script that creates and calls a stored procedure named spInsertDepartment. First, code a statement that creates a procedure that adds a new row to the Departments table. To do that, this procedure should have one parameter for the department name. Code at least two EXEC statements that test this procedure. (Note that this table does not allow duplicate department names.)
Create a function to calculate a shopper’s total spending, excluding shipping and tax amount, with Brewbean’s site in a particular year. Exception handling is needed. Use an anonymous block to call the function and output the result. PL/SQL
Explain the role and purpose of the two codes provided below. Create or Replace Trigger Purchase_EntryAfter Insert or Update of Purchase_Amt on PURCHASE_AGREEMENTFor Each RowBegin if(:New.Purchase_Amt < 0) Then RAISE_APPLICATION_ERROR(‐20100, 'Cannot enter a purchase agreement amount less than zero.'); end if;End; insert into PURCHASE_AGREEMENT values (559, '27 May 2020', ‐1, 12350,'C122',1
Explain in detail the syntax and functionalities of the following Mongoose code: x.findOneAndUpdate({"clientID": req.query.clientid}, {"status": req.query.status}, {new: true}, function (err, data){ /* statement block */ });
Create a trigger called Trig_Enroll_BI on the ENROLLMENT table that fires before an INSERT statement. The trigger must generate a proper error message if the student id or section id or both invalid. Test your code for all possible options. Make sure that all columns that have NOT NULL values (Use system date for all date fields, user id for all created and modified by fields). Display the inserted record from the ENROLLMENT table after a successful enrollment transaction.
4.8 LAB - Select movie ratings with left join The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer The Rating table has the following columns: Code - variable-length string, primary key Description - variable-length string Write a SELECT statement to select the Title, Year, and rating Description. Display all movies, whether or not a RatingCode is available. Hint: Perform a LEFT JOIN on the Movie and Rating tables, matching the RatingCode and Code columns.