ITDB101-Introduction to Database Assignments 1 Marks: 10] Q1. Model Read the given and ER- scenario [Marks: 05] Draw Art Muscat is an art gallery shop in Muscat. They keep information about ARTIST such as their names (unique), birthplace, date_of_birth, and style of art. Each piece of ARTWORK is identified by unique code and described by make_year, title, type and price. An ARTIST can paint one or many ARTWORKS and each ARTWORK is owned by one and only one ARTIST. The information regarding how much time an ARTIST took to paint an ARTWORK is also stored. Every year, the shop conducts EXHIBITION. The place and date of exhibition is recorded in the database and an exhibition may be conducted in more than one place on a specific date. Each ARTWORK is displayed in one and only one EXHIBITION. Each EXHIBITION contains one or many ARTWORK. Finally, the shop keeps information about CUSTOMER. For each CUSTOMER, the customer's unique name, address which consists of street, city and country are stored. A CUSTOMER may buy many ARTWORKS, or may not buy any ARTWORK at all. Each ARTWORK may be bought by one or many CUSTOMER. Q2. Read the given scenario and Draw EER- Model Marks: 051 A STUDENTS in a college is identified by Student_id and described by name, JoiningDate, BirthDate, MobileNumber, and Address. Students are either Probation-Student or Normal Student. PROBATION_STUDENTS have additional attributes ProbationLevel and Number_of_semesters. NON PROBATION students have special attribute called Monthly_Bonus