TREATMENT Column Name TID PID DNAME TDATE SPECIALTY DataType INT(3) INT(5) VARCHAR(10) VARCHAR(10) DATE Constraint PRIMARY KEY a) Write SQL commands to create the above two database table base on the given field names, data types and constraints required. b) Write an SQL command to change the field length of pname to VARCHAR(20) in the patient table. c) Add a 'problem' column in between DNAME and TDATE in the treatment table. The column will allow VARCHAR(20) as a data type. d) Change column DNAME to Doctor_Name. e) Delete the SPECIALTY column in treatment table.

TREATMENT Column Name TID PID DNAME TDATE SPECIALTY DataType INT(3) INT(5) VARCHAR(10) VARCHAR(10) DATE Constraint PRIMARY KEY a) Write SQL commands to create the above two database table base on the given field names, data types and constraints required. b) Write an SQL command to change the field length of pname to VARCHAR(20) in the patient table. c) Add a 'problem' column in between DNAME and TDATE in the treatment table. The column will allow VARCHAR(20) as a data type. d) Change column DNAME to Doctor_Name. e) Delete the SPECIALTY column in treatment table.

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

2. Change the CONTACT view so that no users can accidentally perform DML operations onthe view. SQL commands
Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Press the Run button to produce a result table. Verify the result table displays five movies. Modify the SELECT statement to only select movies released after October 31, 2015: SELECT*FROM Movie WHERE ReleaseDate >'2015-10-31'; Then run the SQL again and verify the new query returns only three movies, all with release dates after October 31, 2015. CREATE TABLE Movie ( ID INT, Title VARCHAR(100), Rating VARCHAR(5), ReleaseDate DATE); INSERT INTO Movie VALUES (1, 'Rogue One: A Star Wars Story', 'PG-13', '2016-12-10'), (2, 'Hidden Figures', 'PG', '2017-01-06'), (3, 'Toy Story', 'G', '1995-11-22'), (4, 'Avengers: Endgame', 'PG-13', '2019-04-26'), (5, 'The Godfather', 'R', '1972-03-14'); -- Modify the SELECT statement:SELECT *FROM Movie;Where ReleaseDate > '2015-10-31';
Database
Question 14 Write a SQL statement to un-grant the select and alter privilege from the user Ahmed. Assume that the table name is 'student' Use the editor to format your answer
11
Create a view named ITEM_INVOICE. It consists of the item ID, description, price, invoice number, invoice date, number ordered, and quoted price for all invoice lines currently on file.
SQL
Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…
Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three attributes as follows: Crush_ID which will be the primary key with the number length of .Crush_Name with the maximum character length of 30.Crush_Description with the maximum character length of 10.Insert exactly three records with the above given attributes. Crush_ID values should be 1, 2 and 3 for the three records. Crush_Description should be ‘Present’ for record 1, ‘Past’ for record 2 and ‘Childhood’ for record 3. If you don’t have any crush from your childhood to present, you can insert some random names. Hmm.. Seems Interesting!! It’s time to implement your programming skills using PL/SQL stored procedures and functions. Create another table called ‘MyDetails’ and should contain exactly four attributes as below: Student_ID,Student_Name ,Student_Term ,Student_GPA If you are not a Master’s student, let’s assume you are a student pursuing masters and taking four semesters or terms.…
13- This clause in SQL join is based on all columns which have the same names, but the data types do not match. a. OUTER JOIN b. USING clause c. ON clause d. NATURAL JOIN
d) Write SQL query to insert the entry ("Shaun", "Paul", "Football", 4) in the table playerEntries(first_name, last_name, category, level).