Match the Chen's notation to the corresponding key and participation constraints.

Question 1: Draw the ER model for the basic information given below. Use the Chen Notation for cardinality and participation constraint. (10 points) All Pakistan Software association holds workshops in collaboration with different software houses. They wish to record detailed information regarding the following aspects. • Intellect delivering workshop – They wish to record complete details about the person who delivers lectures in workshop. Record ID, Name, Email, Address (street, city, state, zip code), Contact number,current job, and qualification details. • Workshop – Record workshop ID, Year, Theme and Venue. • Venue – The venue can be some university, hotel or conference room in a software house. We need to record LocationID, Name, Address (street, city, state,zip code) and Contact number. • Participants – For a participant, record ParticipantID, Name, Designation, Affiliating Institute and Charges. The participating entities have come up with the following rules: • A total of 200 participants are allowed in each workshop each year on a first come, first served basis. • Charges vary with the designation of the participant. • Accommodation is not provided by any host and other expenses are also not entertained.

Consider the following relations to answer Question.Manufacturer (ManufacturerId, MName, DateOfBirth, Gender MAddress, AwardWon)Part (PartNo, PName, Description, ManufacturerId)Order (PartNo, OrderNo, OrderQuantity, OrderedDate, CustomerId)Customer (CustomerId, Email, CName, CAddress, Job, TotalNoOfCustomers)What is/are the most suitable participation constraint (s) to describe has relationship between Order and Part relations?(multiple answers)Select one or more:a.There is partial participation of Order in has relationship.b.There is total participation of Order in has relationship.c.There is total participation of Order with Part.d.There is partial participation of Part in has relationship.e.There is total participation of Part in has relationship.

______ is NOT a type of constraint in SQL language?FOREIGN KEYPRIMARY KEYUNIQUEALTERNATE KEY

Chef and some of his friends are planning to participate in a puzzle hunt event.The rules of the puzzle hunt state:"This hunt is intended for teams of 66 to 88 people."Chef's team has 𝑁N people in total. Are they eligible to participate?Input FormatThe first and only line of input will contain a single integer 𝑁N: the number of people present in Chef's team.Output FormatPrint the answer: Yes if Chef's team is eligible to participate, and No otherwise.Each letter in the output may be printed in either uppercase or lowercase, i.e, the outputs NO, No, nO, no will all be treated as equivalent.Constraints1≤𝑁≤101≤N≤10Sample 1:InputOutput4NoExplanation:The puzzle hunt requires between 66 and 88 people in a team.44 isn't between 66 and 88, so Chef's team cannot participate.Sample 2:InputOutput7YesExplanation:Chef's team has 77 people, and 77 lies between 66 and 88.So, Chef's team can participate in the event.Sample 3:InputOutput8YesExplanation:Chef's team has 88 people, and 88 lies between 66 and 88.So, Chef's team can participate in the event.

Consider the three relations given below.Note that the primary keys are underlined.employees (employee_num, employee_name, contact_num, salary)taskAssignment (employee_num, task_num, task_duration)tasks (task_num, location)Select the list of possible foreign key(s) for the given relations.employee_numemployee_num, task_numtask_numtask_num, task_duration