Q1: Identify one PK from each table and add the constraints using alter. ExerciseCreate a database and schema that contain following tables.Student:RollNumNameGenderPhoneL164123Ali AhmadMale0333-3333333L164124Rafia AhmedFemale0333-3456789L164125Basit JunaidMale0345-3243567Attendance:RollNumDateStatusClassVenueL1641232-22-20162L1641242-23-2016А1L1641253-4-20162ClassVenue:IDBuildingRoomNumTeacher1CS2Sarim BaigCivil7Bismillah JanTeacher:NameDesignationDepartmentSarim BaigAssistant Prof.Computer ScienceBismillah JanLecturerCivil Eng.Kashif zafarProfessorElectrical Eng.2.

PK or Primary Key constraint represents unique values in a column or set of columns. PK column…

Answered: Q1: Identify one PK from each table and…

Engineering

Computer Science

Q1: Identify one PK from each table and add the constraints using alter.

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

[ slide-15.png ] Q1. Please write SQL codes to create below rental database table based on the previous slide (slide 15) Video E-R Modling Diagram child table RENTAL 1. checkout_date and dvd_ID coulmns should be combined together as a composite primary key of the rental table, and rest columns are NOT NULL constraints except the checkin_date column (it might hold NULL values). 2. Rental table is a child table, and the member_id column is a foreign key column which references member table’s member_id primary key column. 3. Rental table is a child table, and the dvd_id column is a foreign key column which references dvd table’s dvd_id primary key column. DESC rental Name Null? Type checkout_date NOT NULL DATE dvd_ID NOT NULL NUMBER(4, 0) member_ID NOT NULL NUMBER(4, 0) checkin_date DATE expred_date NOT NULL DATE
Question 6 Create a query that lists empno, projno, emptime, emendate. Left join the project to the empprojact table using projno and left join the act table using actno and then right join employee table using empno. Where projno is AD3113 and empno is 000270 and emptime is greater than 0.5
Please no written by hand and no emage D As Question 3 A correlated nested query O uses tables from both the inner and the outer queries is executed once for every tuple in the outer query table O both 1 and 2 O neither 1 and 2
which constraint ensure the values in a column are all different? a) Foreign Key b) Restrict c) Unique d) Cascade
DATABASE SQL PLEASE DO NOT COPY AND PASTE FROM PREVIOUS ANSWERS TABLES: drop table tech_supplier cascade constraints;drop table teacher cascade constraints;drop table student cascade constraints;drop table tablet cascade constraints;drop table tablet_amountstatus cascade constraints;create table tech_supplier(supplier_id number(5) primary key,supplier_name varchar2(15),address varchar2(15));insert into tech_supplier values(201,'ali','Amman');insert into tech_supplier values(202,'omar','Zarqa');insert into tech_supplier values(203,'hend','Irbid');insert into tech_supplier values(204,'bana','Amman');insert into tech_supplier values(205,'zaid',null);-----------------------------------------------------------------------------------------------------------------------create table teacher(id number(5) primary key,name varchar2(15),specialty varchar2(25));insert into teacher values(121,'said','physics');insert into teacher values(122,'reem','math');insert into teacher…
Computer Science At UFL, each class is a specific offering of a course (subject). Each row in the Courses table contains information on a single course or subject taught a UFL and each row in the Classes table contains information on a single offering of a course during a specific term. Investigate the two tables, and then write a query that returns the CourseTitle, ClassID, Term, SectionID and FacultyID for classes taught by FacultyID 5000009. SOLUTION:
Delete an employee having ID = 203 (e.g.) Commit changes if that employee’s manager id = 105 Otherwise rollback all the changes. Use Employees table.
With proper explanation else skip it, proper explanation got thumbs-up
Alert dont submit AI generated answer.
7. Write an SQL query to update a view named VP having columns (X,Y,Z) to have columns (X,Y,Z,W) from the table T.
Write an SQL query to add constraint NOT NULL to the column Price. [Hint : Library Table]
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.