Question 1: [10 Marks] Assume your company is developing a generic digital camera online purchasing system that can be sold to different camera stores. An initial analysis phase of the project has resulted in the following informal description of relevant data for the system. A store will be selling a variety of digital cameras and lenses. The digital cameras can have following mutually exclusive optional features: 1. An ability to replace lenses. 2. Cameras with an electronic viewfinder. 3. Cameras with an optical viewfinder. 4. Cameras with an optical rangefinder. Relevant properties of all cameras are the model number, retail price and the number currently in stock. Properties of cameras without an ability to replace lenses that are relevant include a focal length range. Cameras with an ability to replace lenses are related to at least two or more lenses. Properties of a lens that are relevant include the model number, retail price and the number currently in stock. Online customers are either domestic customers or foreign customers. Properties of customers that are relevant include a unique customer number, a customer name, an email address and a shipping address. Each customer may have any number of purchase orders. Each purchase order is for only one unit of any product at a time, either a camera or a lens, and will also have a selling price. Draw an ER/EER schema diagram for this application and upload it to your submission on Crowdmark. Discuss any assumptions you make, and then justify your ER/EER design choices. You must not add any additional attributes or data requirements. Question 2: [10 Marks] Consider a database application which provides a web-based platform where students can practice on tasks assigned by the instructors. In terms of design, following are some major requirements: Instructors will first create their accounts. Relevant details for the instructors are: email, affiliation and name. Instructors will create Courses and add Students to each course. Relevant details for Courses are: course code, term and year. Relevant details for Students are: email and student ID. In Courses, Instructors will create one or more assignment and an assignment will consist of one or more tasks. Each task has a grade. Winter 2023 ITEC 3220 3 Students will work on Tasks and Assignments and will be awarded grade based on their submission. Design an ER/EER schema diagram for this application and upload it to your submission on Crowdmark. Discuss any assumptions you make, and then justify your EER design choices. You must not add any additional attributes or data requirements. Mapping from ER to Relational Model

Questions 3-4: [10 x 2 Marks] Convert the ERDs in questions 1-2 to logical relational schema. Draw the schema using the approach used in Figure 5.7 in the book i.e., relations, attributes, keys, foreign keys must be properly indicated. Also, describe in the text form if there are any other constraints. \

*PLEASE I NEED THE QUESTION FOR 3-4* but you need the answer for 1 and 2 to answer it