i would like it as soon as possible as it is test prep for finals that are due in a few day when i take the test.

i would like it as soon as possible as it is test prep for finals that are due in a few day when i take the test.

1.A public relations company wants a database developed to track its clients’ special events, and attendees at these events. The public relations company also maintains a file of contacts – people who receive mailings or are invited to events. These people have areas of interest (such as Business, Arts, Sports etc.), and they are affiliated with organizations of one of the following types: Print Media, TV Media, Radio Media, Other, Non-media Corporation or Non-Media Non Profit. The public relations company gets information about the events, invites the potential attendees and maintains a list of who will be attending each event. Create a set of tables for the company in 3NF. Represent your answer in DBDL. (i.e. give table name and fields. Underline the primary key.) Draw an entity-relationship diagram.Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)2.You are familiar with the Vet Office database from the Normalization Videos. A. In the Pets table, could the two fields pet name and customer id be used as the primary key instead of pet id? Why or why not?B.The office has decided that there are times when two (or more) vets are needed in an appointment. Revise as necessary. Give the DBDL for ALL tables in the revised database and draw an entity-relationship diagram.

3.Your cousin is opening a used clothing store, where items are sold on consignment. He needs a database to track the store inventory items. When an item is sold, the amount of the consignment (25% of the sales price) and the person to whom it should be paid will be recorded. 

Create a set of tables for the company in 3NF. Represent your answer in DBDL. (i.e. give table name and fields. Underline the primary key.) Draw an entity-relationship diagram.Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)4.You are in charge of keeping track of the players, coaches and referees in an amateur football league. The following design has been given to you, and you need to correct it!Referee (lastname, firstname, street, city, state, phone, division)Coach (Division, phone, lastname, firstname)Player (lastname, firstname, division, coach)Division (name, referee, coach, area)Correct and create a set of tables for the league in 3NF. Represent your answer in DBDL. (i.e. give table name and fields. Underline the primary key.) Draw an entity-relationship diagram.Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)5.Design a database for tracking service data about aircraft for a small airport. There are several models of aircraft, and each model has a specific manufacturer, size (number of seats), and description. Records of maintenance need to be kept – which mechanic made what repair to which aircraft. Mechanics are trained and certified for each model of aircraft separately, but not all mechanics are trained and certified for all aircraft. The hourly rate paid to mechanics varies according to the number of models a mechanic is certified to work on.Create a set of tables for the company in 3NF. Represent your answer in DBDL. (i.e. give table name and fields. Underline the primary key.) Draw an entity-relationship diagram.Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)6. The Sandy Feet Rental Company rents condominiums at the Sand Feet Oceanside resort. There are two buildings, each of which as condos with two or three bedrooms and two bathrooms. In The Shores building, condos are oceanview or oceanfront. The oceanfront condos rent for more than the oceanview properties. The Outrigger building is away from the beach. All the properties rent per week and do not take daily rates. The rate schedule varies by location, number of bedrooms and season of the year. Some properties have high speed internet access and some accept pets. Renters pay a $150 deposit per pet if they want to bring their pet with them. Sandy Feet Rental Company wants to keep their records in a database. The company deals with customers, owners, transactions and housekeeping charges, among other information. They take in all rental amounts, pay housekeeping per unit and disperse rental funds to the property owners while keeping 25% of the rental fee for their services. The cleaning crew charges $50 (for two bedrooms) or $60 (for three bedrooms).Create a set of tables for the company in 3NF. Represent your answer in DBDL. (i.e. give table name and fields. Underline the primary key.) Draw an entity-relationship diagram.Identify any assumptions you made that will assist in my understanding of your solution. (Must be included)