Question

In: Accounting

Discuss why databases are important in accounting information systems. Describe primary and foreign keys, normalization and...

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.

Solutions

Expert Solution

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.


Related Solutions

Discuss why databases are important in accounting information systems. Describe primary and foreign keys, normalization and...
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.
discuss why organizations needs accounting information systems (AIs) and better information managment. how important are they...
discuss why organizations needs accounting information systems (AIs) and better information managment. how important are they and what benefits does the organizations gain from them?
Consider the following relational schema about a University (the primary keys are underlined and foreign keys...
Consider the following relational schema about a University (the primary keys are underlined and foreign keys are italic) STUDENT(StudentID, name, major, year, age) CLASS(ClassName, meetsAt, room, LecturerID) ENROLLED(StudentID, ClassName, mark) LECTURER(LecturerID, name, DepartmentID) DEPARTMENT(DepartmentID, name) Write the SQL statements for the following query: B1. Find the age of the oldest student. B2. Find the ID’s of lecturers whose name begins with “K” \ B3. Find the age of the youngest student who is enrolled in Mechatronics. B4. Find the age...
Create a Database Schema for a hotel reservation system. indicate the Primary Keys, Foreign Keys, and...
Create a Database Schema for a hotel reservation system. indicate the Primary Keys, Foreign Keys, and the one-to-one or one-to-many relationships between the tables. Also describe in a small paragraph the scope of the back-end database, by explaining the different tables and their relations in your schema.
Describe the importance of databases and database management systems in managing organizational data and information. Include...
Describe the importance of databases and database management systems in managing organizational data and information. Include in your discussion the types and some examples of database management systems. Also, address the advantages and disadvantages of using a DBMS.
Accounting Information Systems Our store, store name is a “gray market” distributor of software license keys....
Accounting Information Systems Our store, store name is a “gray market” distributor of software license keys. This means we are reselling software keys for popular software from reputable vendors, including but not limited to Microsoft, Adobe and SAP. The licenses may or may not be directly obtained from the original vendor. For example, we may be selling Windows 10 keys many times cheaper than their retail price. For example, the level of validity that we can attest to a software...
In the world of database design and building it is very important to define Primary keys...
In the world of database design and building it is very important to define Primary keys in each table. The text this week talks about primary keys. What are they and why are they so important to a properly functioning database?
Business Research Databases Let's discuss the role of business research databases in accounting research.
Business Research Databases Let's discuss the role of business research databases in accounting research.
Please create the following tables for a tool rental database with appropriate primary keys & foreign...
Please create the following tables for a tool rental database with appropriate primary keys & foreign keys. Assumptions: 1. Each tool belongs to a category. 2. Each category may have a parent category but the parent category should not have a parent category (so at most two levels). E.g., a Tool A belongs to the electric mower, and electric mowers belong to mowers. Mower has no parent category. 3. Each tool can be rented at different time units. The typical...
Describe how accounting information systems have assisted businesses in developing their cost accounting systems.
Describe how accounting information systems have assisted businesses in developing their cost accounting systems.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT