Introduction to database please, answer the all questions

Module Questions Question 1 Consider the ERD shown produces MANUFACTURER PRODUCT nvoices purchases CUSTOMER (a) Write a narrative description of the objects and relationships (b) How many invoices can exist between an instance of manufacturer and arn instance of customer? (c) How many products can a customer purchase in one instance of the purchases relationship? Question 2 Draw an ERD diagram to represent the following situation for an airline: "XYZ airline has three major resources: airplanes, pilots, and crew members Pilots and crew members have respective home bases, which they return at the end of an assigned flight. A flight must have at least one pilot and one or more crew members attached to an airplane. Each airplane has a maintenance base." Question 3 Give a data dictionary definition of customer-name based on the following verbal specification from a user: "When we record a customer's name, we're very careful to include a courtesy title. This can be either "Mr.," "Miss," "Ms., Mrs.," or "Dr." (There are lots of other titles like "Professor, t" "Sir," etc., but we don't bother with them.) Every one of our customers has a first name, but we allow a single initial if they prefer. Middle names are optional. And of course, the last name is required; we allow a pretty broad range of last names, including names that have hyphens (Smith-Frisby," for example) and apostrophes ("D'Arcy") and so forth 62 We even allow an optional suffix, to allow for things like "Tom Smith, Jr." or "Harvey Shmrdlu 3rd" Question 4 Discuss the stages of the database application systems life cycle