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.
Answers
Answer:
ur ans.. is
Explanation:
D1) A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions. A function is a piece of code designed to calculate specific values and are used inside formulas
D2)Autofill can be used for both rows (horizontally) and columns (vertically). For example, if you enter "1" in cell A1, then drag the fill handle downwards, autofill will automatically fill in the selected cells with the number 1.
D3)The most typical object found in a database is a table. Other types of objects can reside in a schema, such as indexes, constraints, views, and procedures. The table is the most fundamental element found in a database schema. ... Tables, columns, and rows are discussed in the following subsections.
D4)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
D5) Why do we need a Database
Manages 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