Exam 1

Exam 1 - CSC4402 Mid-Term Exam Note: (1). (2). This is a...

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

View Full Document Right Arrow Icon
CSC4402 Mid-Term Exam Wednesday 10-14-2009 Note: (1). This is a close-book test. (2). Please do NOT give alternative answers to questions in III and IV. I(15%). Briefly answer the following questions. (1) Briefly describe ONE important advantage of using database system vs. traditional file system for data management. (2) What are the three levels in the ANSI/SPARC architecture for a database system? What is the main purpose to use such an architecture? (3) What is physical data independence? What is logical data independence? II(25%). The following shows the relation schemas for a relational database, describing departments, teachers, students, courses and the student’ senrollment in courses. The primary key attribute(s) are under- lined . D: ( D #DNAME BUDGET) for departments T: ( T #TNAME D# CITY) for teachers (D# is a foreign key) S: ( S #SNAME DEGREE D# CITY) for students (D# is a foreign key) C: ( C #CNAME T#) for courses (T# is a foreign key) E: ( S # C #GRADE) for enrollments (S# is a foreign key ,C#isaforeign key)
Background image of page 1

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

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

This note was uploaded on 01/25/2010 for the course CSC 4402 taught by Professor Staff during the Fall '08 term at LSU.

Page1 / 3

Exam 1 - CSC4402 Mid-Term Exam Note: (1). (2). This is a...

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

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