DB 3 - Database Documentation - Technical Aspect

Question 1

What is business rules?

Answer 1

Its a statement that describes the constraint on how database is to be used in accordance to the perception of the organization
EX: A student cannot have more than 2 limited books borrowed

Question 2

What is entity relationship model?

Answer 2

ER model translates analysis of relationship of entities in a database into a graphical diagram known as ERD

Question 3

What are the 3 levels of ER?

Answer 3

Conceptual ER
Logical ER
Physical ER

Question 4

What is normalization?

Answer 4

A technique for producing a set of relations with desirable properties, given the data requirements of an enterprise

Question 5

What is the purpose of normalization?

Answer 5

To create an accurate representation of the data, its relationships and constraints by grouping attributes into relations to minimize data redundancy and reduce file storage space required

Question 6

Explain the 3 types of normal form

Answer 6

NF 1 - get rid of any columns that holds the same data, split up data, each row must be unique
NF 2 - get rid of data no dependant on EVERY part Primary Key
NF 3 - Keep splitting it up