X hits on this document

Powerpoint document

C20.0046: Database Management Systems Lecture #1 - page 22 / 40

147 views

0 shares

0 downloads

0 comments

22 / 40

M.P. Johnson, DBMS, Stern/NYU, Sp2004

22

Example: university database

Conceptual schema:

Students(ssn: string, name: string, login: string, age: int, gpa: real)

Courses(cid: string, cname: string, credits: int)

Enrolled(sid:string, cid:string, grade: string)

Physical schema:

Relations stored as unordered text files.

Indices on first column of each rel

External Schema (View):

Course_info(ssn: string, name: string)

My_courses(cname: string, grade: string)

Document info
Document views147
Page views147
Page last viewedSun Jan 22 14:44:52 UTC 2017
Pages40
Paragraphs688
Words2138

Comments