Draw an ER diagram‚ and write a database design outline for a database appropriate for this information.

Tour operator: You manage a tour company that operates tours of local historical and natural attractions. You have several dozen different tour packages, each with a name (such as “Exploring Native Ruins” or “Bird‐ Watching Hike”), a scheduled duration in minutes, a per‐guest price, and a maximum number of guests. You also have a staff of dozens of guides, for each of which you want to store a first name, middle initial, last name, and date hired. For each guest who has ever taken or has booked a reservation to take one of your tours, you want to store a first name, middle initial, last name, gender, date of birth, and mobile phone number. You group guests into households, for each of which you want to store address information (street address, city, state, and zip code), and a primary credit card number. Assume that you have access to a national zip code table that you wish to include in your database design, and that each guest can be a member of only one household. A tour consists of one of your guides taking a group of guests on one of the tour packages. For each tour, you want your system to remember what tour package it was, which guide conducted it, and which guests participated. You also want to store a scheduled start date and time, and an actual completion time (blank for tours that are in the future). Over time, guests can participate in more than one tour. Draw an ER diagram‚ and write a database design outline for a database appropriate for this information.

find the cost of your paper

Give a flannel board presentation.

Give a flannel board presentation. 1. Set up area with board. 2. Check pieces. 3. Practice. 4. Place pieces in order of appearance. 5. Gather children. 6. Place pieces out….

What is a dramatic play kit?

Answer the following questions related to speaking goals. 1. How can the goals of a program be met? 2. When children are interested in an object or event, what should….

Write down teacher questions that could lead a child to a discovery and promote the child’s verbal expression of the discovery in the following situations. 1. A bird’s nest is….