B. Short answer questions (1).
1. What do you mean by referential integrity? Take example to explain.
2. How can you change the field properties of a table?
3. What is a query in a DBMS? What language has been developed to express queries?
4. Give example of a simple SQL query and explain how it works.
5. What is the use of forms? Give any one way to create forms.
Answers
Answer:
1) Referential Integrity refers to the ability of the database to keep related data from being corrupted. The data references between tables must remain intact. For example in the Personnel System demonstration Iapplication database, all of the records in the Section table require a Department Code
2) To edit a field's properties:
Click the table name in the table bar of your app.
Click Settings in the page bar, then click Fields on the Settings page.
Click the field name to access its properties.
Click the name of the field that you want to modify. If you have lots of fields, you may need to scroll down to find it, or filter or sort the list.
Make the necessary changes, and then click Save.
Tip: For information about a particular field property, click Help in the global bar, and click the About Field Types link. In the help file, click field type to see help on the properties for that field type.
Q 3 and Q4 I don't know
Q5 A form is a database object that you can use to enter, edit, or display data from a table or a query. You can use forms to control access to data, such as which fields of data are displayed. For example, certain users may not need to see all of the fields in a table.
Please mark me as brainliest
Answer:
Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.
Explanation:
plz like