MIDTERM EXAM 1: DATABASE MANAGEMENT SYS Chapter 1
What does the first database environment consist of?
Hardware(range from PC to network computer)
What is the four limitation of FBS?
Incompatible file format(Since department manages their own database each database will have a different kind of file format)
What is considered data inconsistency?
It's the same person's data but with different values in the database.
What is database?
Its where we store our data.
What does the fifth database environment consist of?
People(user of the database system)
What does the fourth database environment consist of?
Procedures(instruction and set of rules that should be applied to the design and use of data and DBMS. )
What is the fifth limitation of FBS?
Proliferation of software(the file-based system is a hard-coded systems)
What is File Based System?(in simple terms)
Recorded data and stored it in a file cabinet
What is the first limitation of FBS?
Separation and isolation of data(data not being shared inside the company)
What does the second database environment consist of?
Software(DBMS with application programs)
Explain what data redundancy?
The saved data is stored more than once.
What is view in a database?
a subset of the data depending on your job, user got their own view
What are advantages of DBMS?
control of data redundancy data consistency enforcement of standards economy of sale
What is DBMS?
its used to manage database.
Why do we need view ?
reduce complexity provide level of security customize the appearance of database present a consistent, unchanging picture of the structure of the database
How will DBMS be used ?
A computer program that interacts with the database by issuing an appropriate request (SQL statement) to the DBMS.
What is File Based System?(in technical terms)
Collection of application programs that perform services for end user.
What are the disadvantages of DBMS?
Complexity Size Cost of DBMSs Additional hardware cost
What is the third limitation of FBS?
Data dependence(when the data changes the systems needs to be changed)
What does the third database environment consist of?
Data( used by the organization and a description of data schema)
What is the second limitation of FBS?
Duplication of data(FBS will most likely have data redundancy)