Qn 4: Draw an ERD using the following scenario: Prepare an Entity Relationship Diagram (ERD) showing all primary and non-primary key attributes for the scenario provided below. Fly Every Where (FEW) maintains a database about airlines, passengers and their reservation to perform their business activities. The information about the data stored by FEW database is as follows: • FEW has collaborations with many airlines. Each airline has a unique identification number, contact person name and contact number. • The airline has one or more aircrafts. Information stored about aircraft includes a model number, a unique registration number, and the capacity to take one or more passengers. • An aircraft can fly in many flights but each flight is carried by a single aircraft. • Each flight is referenced by unique identifier flight number, a departure airport, a destination airport, departure date and time and arrival date and time. • Passengers are referenced by their unique email ID, first name, last name, mobile and address. racted from: Database Processing: Fundamentals, Design, and Implementation, David M. Kroenke and David Auer, 14th ed, Global Edition, Pearse prial Compiled by: Anupam Makhija King's Own Institute • A passenger can book one or many seats on a flight. A passenger can book any number of flights and a flight cab be booked by any number of passengers. • When a booking done, also number of seats booked and amount is recorded. Questions: a) Identify attributes and associate them with entity or relationship types. Represent each attribute in your ER diagram. b) Identify the main relationship types between the entity types identified in part (a) and represent each relationship on your ER diagram. c) Show the primary and foreign key attributes for each entity.

Can you give an example of an entity in the MiniMarket Warehouse Database, please input in the table like in the picture THANK YOUU

1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.

Using er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd. You need to design a database to keep track of clubs at a high school. Attributes: A student may only join one club Some students do not join at all Club needs to have one student Need to capture students: Name  Address Year of grad All Phone numbers   Club name Club advisor Meeting dates