Example: University Database
Conceptual schema:
- Students(sid: string, name: string, login: string,
age: integer, gpa:real)
- Courses(cid: string, cname:string, credits:integer)
- Enrolled(sid:string, cid:string, grade:string)
Physical schema:
- Relations stored as unordered files.
- Index on first column of Students.
External Schema (View):
- Course_info(cid:string,enrollment:integer)