Homework1Sol - Database Management Systems (COP 5725)...

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

View Full Document Right Arrow Icon
Database Management Systems (COP 5725) (Spring 2011) Instructor: Dr. Markus Schneider TA: Nam Nguyen Homework 1 Solutions Name: UFID: Email Address: Pledge (Must be signed according to UF Honor Code) On my honor, I have neither given nor received unauthorized aid in doing this assignment. _______________________________________________ Signature For scoring use only: Maximum Received Exercise 1 30 Exercise 2 30 Exercise 3 40 Total 100
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exercise 1 (Knowledge Questions) [30 points] 1. What is a database? What are its implicit properties? [4pts] A database is a collection of related data. A database has the following implicit properties: + Representing some aspect of the real world (called the miniworld). Changes to this miniworld are reflected in the database. + A database is a logically coherent collection of data with some inherent meaning. A random assortment of data cannot correctly be referred to as a database. + A database is designed, built, and populated with data for a specific purpose. It has an intended group of users and some preconceived applications in which these users are interested. 2. What is a DBMS? What are the processes that a DBMS facilitate? [4pts] A DBMS is a collection of programs that enables users to create and maintain a database. The DBMS is a general-purpose software system that facilitates the processes of Defining, Constructing, Manipulating, and Sharing databases among various users and applications. 3. What are the problems of using a file system? [4pts] Repeated occurrence of the same data in different files (redundancy), lacking logical concordance of file contents (inconsistency), changes of the file structure lead to changes of the application program, extensions of the functionality of an application program lead to new
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/14/2012 for the course COP 5725 taught by Professor Staff during the Spring '08 term at University of Florida.

Page1 / 5

Homework1Sol - Database Management Systems (COP 5725)...

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

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