The constraints that cannot be modeled on the ER diagram should be handled by:Choose one answer. a. Listing them on the separate document to be coded b. Always let the network architect handle them c. Explain to the user so they can enforce them d. All constraints must be modeled and shown on the ER diagram

Which of the following should we always do when preparing to map an ER diagram to relations?Select one:a.Normalize the ERD until no more normalization can be doneb.Check that the DBMS can interpret the constraints in the ERDc.Make sure that we have simplified the ERD as much as possibled.Make sure that our ERD has only one entity and one relationship

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.

Find the minimum number of tables required to represent the given ER diagram in relational model-

Can you help me express the following situation with an ER diagram： On a large online retail platform, different users can log in using their unique identifiers and shop for various items. Each of these items comes with a unique identification code, name, price, and detailed description. Users, apart from their unique identifiers, also provide their name, email, and shipping address. These users can make multiple purchases on different dates, with each transaction assigned an identification code unique to the user, along with recording the date of the transaction and the total cost. Each transaction can consist of one or more items, and the same item could be part of various transactions made by the same or different users.

A UML diagram that facilitates requirements gathering and interacts between system and external users, is called asSelect one:Flowchart diagramSequence diagramUse case diagramData flow diagram