3902Ch2 - Database system concepts and architecture Sept...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 1 Outline: Concepts and Architecture (Chapter 2 - 3rd, 4th , 5th ed.) • Database schema • Working process with a database system • Database system architecture • Data independence concept • Database language • Database application • Interfaces • Database environment Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 2 Schema: a description of a database -- meta data • the intension of the database Schema evolution: if the database definition changes, we say it evolves. Database State : the data in the database at a particular point in time • the extension of the schema Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 3 Sample database Student Name StNo Class Major Smith 17 1 CS Brown 8 2 CS Course CName CNo CrHrs Dept Database 8803 3 CS C 2606 3 CS Section SId CNo Semester Yr Instructor 32 8803 Spring 2000 Smith 25 8803 Winter 2000 Smith 43 2606 Spring 2000 Jones Grades StNo SId Grade 17 25 A 17 43 B Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 4 University database schema: Course Cname string(20) CNo string(20) CrHrs integer Dept. String(20) grades StNo integer SId integer Grade String(20) Student Name string(20) StNo integer Class integer Major String(20) Section SID integer CNo string(20) Semester integer Yr integer Instructor string(20) Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 5 Schema evolution: Course Cname string(20) CNo string(20) CrHrs integer Dept. String(20) Student Name string(20) StNo integer Class integer Major String(20) Prerequisite CNo string(20) Pre-CNo string(20) … ... n e w t a b l e a d d e d Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 6 Database evolution: Course Cname string(20) Cno string(20) CrHrs integer Dept. String(20) Student Name string(20) StNo integer Class integer Major String(20) Age integer Sex string(20) … ... n e w a t t r i b u t e s a d d e d Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 7 Sample database Student Name StNo Class Major Smith 17 1 CS Brown 8 2 CS Course CName CNo CrHrs Dept Database 8803 3 CS C 2606 3 CS Section SId CNo Semester Yr Instructor 32 8803 Spring 2000 Smith 25 8803 Winter 2000 Smith 43 2606 Spring 2000 Jones Grades StNo Sid Grade 17 25 A 17 43 B Database system concepts and architecture Sept. 2009 Yangjun Chen ACS-3902 8 Database state changed: Student Name StNo Class...
View Full Document

This note was uploaded on 02/17/2010 for the course ACS ACS-3911 taught by Professor Chen during the Spring '10 term at Windsor.

Page1 / 27

3902Ch2 - Database system concepts and architecture Sept...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online