Question

D.
Answer the following questions.
1. Differentiate between a formula and function with an example.
2. Explain the Autofill feature with example.
3. Explain the different elements of a database with an example.
4. What is a primary key? What is the advantage of creating a primary key in a table?
5. Explain in short the need for creating a database.​

Answer 1

9

Answer:

4)

Explanation:

Using the primary key, you can easily identify and find unique rows in the database table. They allow you to update/delete only specific records by uniquely identifying them. The table's data is sorted based on the primary key. They help you avoid inserting duplicate records in a table.

5)anages large amounts of data. A database stores and manages a large amount of data on a daily basis. ...Accurate. A database is pretty accurate as it has all sorts of build in constraints, checks etc. ...Easy to update data. ...Security of data. ...Data integrity. ...Easy to research data.