Question

Discuss why databases are important in accounting information systems. Describe primary and foreign keys, normalization and database cardinalities. Why are each important to the database design? Your initial posting should be 250-500 words and must be submitted by Thursday, 11:59 pm MST, of this week.

Answer 1

Databases are very important in the accounting systems why because the are a huge information to be stored in accounting because every transaction should be supported with the required documents.

The usage of accounting information is huge in every departments so database provides facilities to share information in different departments at a time .

Primary key :- this is the key used to encrypt the plain data into encrypted data.

Foreign key :- it is the key used to decrypt the encrypted data it has the same password that primary key has.

Normalization :- it is a process of structuring a relational database in accordance with a series of so called forms in order to reduce the data redundancy and improve data integrity.

Data cardinalities :- cardinality refers to the uniqueness of data values contained in a columnn. High cardinality refers to high percentage of unique values. Low cardinality means low percentage of unique values.

All the above points are very crucial in the database design

Every database should consists of primary key and foreign key is required for security purposes.

Normalization is very important for controlling data redundancy .

Database cardinalities are important for the recognition of unique values .

These are all the points about the required topics in the question.

I hope, all the above mentioned points are useful and helpful to you.

Thank you.