Answer the following questions based on the database given below:1. Id

1.	Answer the following questions based on the database given below:1. Identify the primary key and justify your answer.2. Suggest suitable data type for Unit_Cost and justify your answer.3. If the database is sorted in ascending order of UnitCost. What is the product name of last record?4. How will you ensure that Supplier_No must not be empty?5. To add the details of new product, what should the user add: record or field? Write the steps for the same.6. How will you ensure that ‘1’ must appear in Supplier_No, if no value is entered?7. How many records and fields are there in the above table?8. It is needed to add photograph of the product in the database. Which is suitable data type for the same?
Answer» 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table. 2. The suitable data type for the field Unit_Cost is Number because this field in the table contains the value in numbers only. 3. Crayons. 4. By setting the Required property to Yes. 5. To add the details of the new product the user should add a record. The steps are as follows: Step 1 Open the database. Step 2 Open the table in which you want to add a record in a Datasheet View. Step 3 If you open the table, a new blank record will automatically appear at the end of the table. Step 4 Type the data into the fields. Step 5 Save the table. 6. By setting the property Default Value which is to be set as 1. 7. Records = 8, Fields = 8 8. The data type OLE Object is suitable for adding the photograph of the product to the table.

Answer the following questions based on the database given below:1. Identify the primary key and justify your answer.2. Suggest suitable data type for Unit_Cost and justify your answer.3. If the database is sorted in ascending order of UnitCost. What is the product name of last record?4. How will you ensure that Supplier_No must not be empty?5. To add the details of new product, what should the user add: record or field? Write the steps for the same.6. How will you ensure that ‘1’ must appear in Supplier_No, if no value is entered?7. How many records and fields are there in the above table?8. It is needed to add photograph of the product in the database. Which is suitable data type for the same?

Answer»

1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.

2. The suitable data type for the field Unit_Cost is Number because this field in the table contains the value in numbers only.

3. Crayons.

4. By setting the Required property to Yes.

5. To add the details of the new product the user should add a record. The steps are as follows:

Step 1 Open the database.

Step 2 Open the table in which you want to add a record in a Datasheet View.

Step 3 If you open the table, a new blank record will automatically appear at the end of the table.

Step 4 Type the data into the fields.

Step 5 Save the table.

6. By setting the property Default Value which is to be set as 1.

7. Records = 8, Fields = 8

8. The data type OLE Object is suitable for adding the photograph of the product to the table.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment