Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
THESE ARE SOME BASIC DATABASE LABS ASSIGNMENT EASY FOR BEGINNERS..THEY CONTAIN OUPUT PICS AND CODE AS WELL
Typology: Lab Reports
1 / 5
This page cannot be seen from the preview
Don't miss anything!
EXPERIMENT 3 – Data Definition Languages Lab# 3 EXERCISE Given Table: Employee Queries: create table Employee( Empn varchar( 15 ), EmpName varchar( 20 ), Designation char( 20 ), Deapartment char( 20 ), Email varchar( 30 ), Phone varchar( 20 ), ) insert into Employee values ('E-100','Chuck','Coordinator','Administration','[email protected]','523- 3333'), ('E-101','Mary','Manager','Finance','[email protected]', '523-1111'), ('E-102','Sally','Supervisor','Planning','[email protected]','523-2222'), ('E-103','Alan','Adminstrator','Administratio','[email protected]','523- 3333'), ('E-104','Qasim','Assistant','Finance','[email protected]','523-1111') select * from employee
Write a query to set EMPNO as the primary key. Ans: Constraint EmpId Primary Key(Empn)
Write a set of queries to implement following ER Mode in SQL Server. Queries : create table Student( StdNo varchar( 20 ), StdFirstName varchar( 30 ), StdLastName varchar( 30 ), StdAdmitSemester char( 2 ), StdAdmitYear char( 4 ), StdEnrollStatus varchar( 10 ), Constraint STDID Primary Key(StdNo) ) create table Paper( PaperNo varchar( 10 ), PaperSubmitDate date, PaperTitle varchar( 10 ), PaperAccepted char( 2 ), PaperType Char( 8 ), STDDNo varchar( 20 ), Constraint PNO Primary Key(PaperNo), Constraint Pre_StdID Foreign key(StddNo) references Student(StdNo) ) insert into Student values ('S-001','Hadeed','Naeem','1','2020','Enrolled'), ('S-002','Ali','Akbar','3','2021','Enrolled'), ('S-003','Mubashar','Hussain','5','2022','Enrolled')
insert into Paper values ('P-001','1-2-2021','HRM','Y','OHT','S-001'), ('P-002','3-2-2021','CVT','N','MID','S-002'), ('P-003','5-2-2021','DSA','Y','Final','S-001') Select * from Student Select * From Paper Table output : Diagram of Self reference entity :
