Database Management Systems Assignment for BSCIT Semester 1

August 2009
Bachelor of Science in Information Technology (BScIT) – Database Management Systems/
Diploma in Information Technology (DIT) – Semester 1
BT0066 – Database Management Systems – 3 Credits
(Book ID: B0950)
Assignment Set – 1 (60 Marks)

Answer all questions 10 x 6 = 60
1. List out the database implicit properties.
2. What are the applications of SQL Server 2000?
3. Distinguish between three major types of architectural data models.
4. Explain various file organizations in detail.
5. What is the goal of query optimization? Why it is important?
6. What is relational completeness? If a query language is relationally complete, can you write any desired query using that language?
7. What is relational completeness? If a query language is relationally complete, can you write any desired query in that language?
8. What is the basic purpose of 4NF?
9. How might a distributed database designed for a local area network differ from one designed for a wide area network?
10. What are the drawbacks of current commercial databases?

August 2009
Bachelor of Science in Information Technology (BScIT) – Semester 1/
Diploma in Information Technology (DIT) – Semester 1
BT0066 – Database Management Systems – 3 Credits
(Book ID: B0950)
Assignment Set – 2 (60 Marks)

Answer all questions 10 x 6 = 60
1. Differentiate between physical data independence and logical data independence.
2. Explain the three level architecture of DBMS.
3. Explain the distinctions among the terms primary key, candidate key, and super key.
4. Explain various storage devices and their characteristics.
5. What are the benefits of making the system catalogs relations?
6. Explain the statement that relational algebra operators can be composed. Why the ability to compose operators is important?
7. What is an unsafe query? Give an example and explain why it is important to disallow such queries.
8. Define the term functional dependency.
9. Discuss the relative advantages of centralized and distributed databases.
10. List a few requirements for multimedia data management.

this assignment is power by:SMU website