Unit 5 - Database Concepts and Managing Data

Question 1

What is the relationship between database and information systems?

Answer 1

Information Systems maintain and access the transactional data in databases. They are the storage part of IS.

Question 2

What are the problems of non-database systems?

Answer 2

“RII”
Data Redundancy
Data Inconsistency
Data Isolation

Question 3

What is the relationship between database and DBMS?

Answer 3

Database Management Systems (DBMS) –software through which users and application programs interact with a database. 
Software used to create, manage, maintain, and manipulate a database.

Question 4

What are the benefits of DBMS?

Answer 4

Data Security
Data Integrity (fx no text in number fields)
Data Independence (of certain applications)

Question 5

What are the characteristics of a relational database?

Answer 5

Data stored in tables with one primary key and maybe foreign keys. This is done so that you can link relating tables

Question 6

What is the main purpose of normalization in database?

Answer 6

Split data out on several tables in order to reduce duplication of data.

Question 7

What is the relationship between tables in a database and forms?

Answer 7

Forms are made to display and enter data from and to tables in a more convenient way.

Question 8

What is the relationship between database queries and forms?

Answer 8

Database queries is a way to perform more complicated searches in a database. FX SQL