1. Give answers for the following - I. Identify and define (any) three (3) attribute types...

 

Transcribed Image Text:

1. Give answers for the following - I. Identify and define (any) three (3) attribute types that you can see in table 1, given below. [for exomple, Customer_Gender is a required attribute. DON'T USE THIS ATTRIBUTE TYPE] Table Name: Customer Customer_id Customer_Name Customer_Gender Customer_DOB Customer_Phoneno 1233456 John M 2000-09-01 0175690981, 0184589019 Table 1 (6 marks) II. Consider the business rule - "A Student is involved in many activities. Each activity has many students" and answer the below questions. a. Draw an ERD to convert the many to many relationships show in the ABOVE BUSINGESS RULE into an accepted solution for database, with the help of a suitable associative entity. (Give 2-3 attributes per entity) Show this associate entity as a 'weak entity'. b. Define associative entity? c. List the two conditions that must be met before an entity can be classified as a weak entity. (5+2+2=9 marks) 1. Give answers for the following - I. Identify and define (any) three (3) attribute types that you can see in table 1, given below. [for exomple, Customer_Gender is a required attribute. DON'T USE THIS ATTRIBUTE TYPE] Table Name: Customer Customer_id Customer_Name Customer_Gender Customer_DOB Customer_Phoneno 1233456 John M 2000-09-01 0175690981, 0184589019 Table 1 (6 marks) II. Consider the business rule - "A Student is involved in many activities. Each activity has many students" and answer the below questions. a. Draw an ERD to convert the many to many relationships show in the ABOVE BUSINGESS RULE into an accepted solution for database, with the help of a suitable associative entity. (Give 2-3 attributes per entity) Show this associate entity as a 'weak entity'. b. Define associative entity? c. List the two conditions that must be met before an entity can be classified as a weak entity. (5+2+2=9 marks)

Answer rating: 100% (QA)

Answer i Three Attributes from Table Customer 1 Customerid data type integer this attribute is used to store customer ID and it should be unique for every entry in the table this is an example of Key ... View the full answer