Create an example of a table that is in first normal form but not in second normal form using the types of entities found in the Colonial Adventure Tours database (trips, guides, clients, and reservations) and an example of a table that is in second normal form but not in third normal form using the types of entities found in the Colonial Adventure Tours database. Justify your responses in each situation and demonstrate how to convert to the higher forms.

Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables. Requirements: Show the results of the normalization as individual tables Show the FK and PK columns using Visio's notation You must solve the multi-column issue with grades (Hint: This will require a new column) Show the 3-part column definition as noted Show min/max cardinality   Tables are attached

WORKING IN CENGAGE AND CAN'T FIGURE OUT THIS TASK. I TRIED OTHER STAEMENTS BUT DID NOT WORK EITHER. PLEASE HELP! Task 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. To combine strings into a single column you must use the CONCAT function which combines two or more strings together and its syntax is the following: CONCAT(string1, string2, ....)

BITS Corporation Exercises The following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram. 1. Indicate the changes you need to make to the design of the BITS database to support the following situation. A client is not necessarily represented by a single consultant but can be represented by several consultants. 2. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order. 3. Indicate the changes you need to make to the BITS database design to support the following situation. The region where clients are…

Instructions: In this assignment, you will convert an Entity-Relationship diagram into a set of related tables. Given the following ERD, write the table definitions for the entities displayed below.  You do not have to indicate data types nor “not null” constraints in this lab.  Use the format TableName ( attribute, attribute…attribute).  Designate primary keys with an underline and foreign keys with a broken underline.  To illustrate, the Regions and Countries table definitions have been created for you below the diagram.  Type your answers in this document and upload it to the appropriate Blackboard assignment link by Monday at 11:59 p.m. ET of this module/week. Note that you should read the “Table Conversions Explained” document in your Reading & Study folder.  I created it to help you better understand how ERDs will ultimately be transformed into real tables.   ERD for the Hourglass timekeeping database

Based on BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram.  2. Indicate the changes you need to make to the design of the BITS database to support the following situation.  There is no relationship between clients and consultants.  When a client places an order (service request), it may be performed by any consultant.  On the order, identify both the client placing the order and the consultant responsible for the order.

StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.

Customer Trip Guide CustomerNum TriplD GuideNum LastName TripName StartLocation LastName FirstName FirstName Address State Address City State PostalCode Distance MaxGrpSize Туре Season City State PostalCode PhoneNum Phone HireDate Reservation ReservationID TripID TripDate NumPersons TripPrice OtherFees CustomerNum TripGuides TripID GuideNum

ERD

using the design file in the image attached to the question : Normalize the database in the design file Be aware of the possibility of duplicate data. Name in Role and Employee and Emp_Contact_name all refer to the same data. Name and Email in Vendor refer to the Vendor. Assumptions made: An employee works with one or more vendors. An employee may have none or many dependents. An employee may have many roles over the employee's work history and a record should be retained for each role.