Download Example Tables-Introduction to Database System-Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!
DEPT ( depId , depName, depHead ) PROGRAM ( prName , totSem, prCredits, depId ) COURSE ( bbbbbb , crName, crCredits, crLevel) SEMESTER ( semName , stDate, endDate) CROFRD ( crCode, semName , facId ) FACULTY ( facId , fName, fQual, fSal, rank) STUDENT ( stId , stName, stAdres, CurSem, cgpa, prName ) ENROLL ( stId , crCode , semName , mTerm, sMrks, fMrks, totMrks, grade, gp) SEM_RES ( stId , semName , totCrs, totCrdts, totGP, gpa) Department of Computer Science
DEPT (depId, depName, depHead )
Department of Computer Science depId depName depHead CS Computer Science BI Bioinformatics MS Management Science EE Electronic Engineering ME Mechanical Engineering
COURSE (crCode, crName, crCredits, crLevel)
Department of Computer Science crCode crName crCredits crLevel CS3213 Operating Systems 3 3 CS2313 Database Systems 3 2 FM3233 Financial Management 3 3 FM2313 Money & Capital Market 3 2 docsity.com
SEMESTER (semName, stDate , endDate ) Department of Computer Science semName stDate endDate S10 23-01-2010 08-06- F10 25-08-2010 15-01- S11 05-02-2011 15-06- F11 20-08-2011 20-01-
Department of Computer Science
stId stName stAdr prName curSem cgpa
BC1001 Sohail
Dar
H#14, F/8-
4,Islamabad.
MCS 4 3.
BC1002 Shoaib
Ali
H#23, G/9-
1,Islamabad
BCS 3 3.
BI1003 Tahira
Ejaz
H#99, Lala
Rukh Wah.
MCS 5 3.
BC1104 Arif Zia H#10, E-8,
Islamabad.
BIT 5 3.
STUDENT (stId, stName, stAdres, prName, CurSem, cgpa)
CROFRD (crCode, semName, facId ) Department of Computer Science crCode semName facId CS2313 S2011 F FM3233 S2011 F CS2313 F2011 F
Department of Computer Science
Selection Example
Curr_Sem > 3
(STUDENT)
Studid = „S1038‟
(STUDENT)
Department of Computer Science Selection Example Cont’d) F2345 Usman H#Car409 21000 lecturer F3456 Tahir H#Bac100 23000 Asso Prof F4567 Ayesha H#Car301 27000 Asso Prof F5678 Samad H#Irv342 32000 Professor FacID Fname Address Salary Rank
Department of Computer Science
Projection Example
FacID, Salary
(Faculty)
Fname, Rank
(Faculty)
Facid, Salary,Rank (Faculty)
Department of Computer Science
Union Example
C2345 P1245 3 Operating Sytems C3456 P1245 4 Database Systems C4567 P9873 4 Financial Management C5678 P9873 3 Money & Capital Market CID ProgID Cred_Hrs CourseTitle C4567 P9873 4 Financial Management C8944 P4567 4 Electronics courseId Program Cred_Hrs CourseTitle
Course
Course
Department of Computer Science
Difference (-) Example
C2345 P1245 3 Operating Sytems C3456 P1245 4 Database Systems C5678 P9873 3 Money & Capital Market CID ProgID Cred_Hrs CourseTitle
Course1 – Course
Department of Computer Science
Cartesian Product (X)
Example
Course X Registration
C3456 Database Systems C4567 Financial Management C5678 Money & Capital Market CID CourseTitle S101 Ali Tahir S103 Farah Hasan SID StudName
Course Registration
Department of Computer Science facId facName dept salary rank F F F F 32000 27000 23000 21000 Samad MNG Professor Ayesha ENG Asso Prof Tahir CSE Asso Prof Usman CSE lecturer
COURSE
Introduction to F Accounting C Money & Capital F Market C C4567 Financial Management C3456 Database Systems F crCode crTitle fId
FACULTY
Theta Join Example
rank = ‘Asso Prof’
(FACULTY)) X COURSE
Department of Computer Science F4567 Ayesha ENG 27000 Asso Prof F4567 Ayesha ENG 27000 Asso Prof F4567 Ayesha ENG 27000 Asso Prof F4567 Ayesha ENG 27000 Asso Prof F3456 Tahir CSE 23000 Asso Prof F3456 Tahir CSE 23000 Asso Prof F3456 Tahir CSE 23000 Asso Prof F3456 Tahir CSE 23000 Asso Prof facId facName dept salary Rank Introduction to F Accounting C C3456 Database Systems F C4567 Financial Management Money & Capital F Market C Introduction to F Accounting C Money & Capital F Market C C4567^ Financial Management C3456 Database Systems F crCode crTitle fId (σ
rank = ‘Asso Prof’
(FACULTY)) X COURSE
