3.The following ER diagram is designed for the situation described in Chapter 2 Problems and Exercises 2-39a on page 104. Transform the following E-R diagram to a relational schema that shows referential integrity constraints, primary keys and foreign keys. Billing Rate EMPLOYEE Employee ID Employee Name Employee Address Employee Birthdate PROJECT Project ID Project Name Project Start Date Answer the above questions and solve the problems. Write your answers and draw the graphic models in a MS Doc file.

I'm having trouble with this question with my data modeling class. " Scenario: Jonny is appointed as an intern position, which might lead to a junior database architect role in TechTrend Corporation (TTC). Jonny is assigned to redesign two legacy tables related to "Suppliers," to be normalization compliant. The following business rules are provided. Business Rules: 1. Suppliers can be local or national, thus can have multiple locations. 2. Any location can supply items to TechTrend. 3. Any location manager can have a separate pricing deal with TechTrend, based on production process specific to that location and localization efficiency. 4. Each location has a contact person assigned to TechTrend. 5. Traditionally, TechTrend dealt with a singular location, at the most two. With rapid growth in business, the TTC officials are finding better leverage possibilities to negotiate beneficial terms with suppliers in multiple locations. 6. The DB administrator has specifically requested Johnny…

You have an application domain that consists of Cities, Towns, and Neighborhoods. A City has a name, zip code, state, and a country. A Town has a name, zip code, state, and country. A Neighborhood has a name, coordinate, and population. Using a relational model, what are Students, Courses, and Sections called? Select one: a. Attributes b. Constraints c. Entities d. Relations

Consider the scenario described by the following statement: “Kangaroos, wombats and koalas are all kinds of marsupials.” a.) Model this statement using the crow’s foot modelling technique.  Create your diagram in draw.io (or equivalent), save it as either a JPG or PNG file format, and upload your image using the "Files" area below. b.) Write the SQL code to create the Tables from the entities you modelled in the previous part.   Write your code in the text area (above the "Files" area).