Question: Create a unique SQL database for a TRAVEL COMPANY 2) Your database must contain at least six (8) tables 3) Normalize your tables up to

Create a unique SQL database for a TRAVEL COMPANY

2) Your database must contain at least six (8) tables

3) Normalize your tables up to the 3rd normal form (3NF).

4) Show your 3NF Normalization SQL script for this step.

5) Create an ER Diagram for that database (Travel Company)

6) Create a database in SQL Server and insert at least 10 records into each table.

7) Provide the detailed steps that you have used to create each database table with data in the SQL server

Step by Step Solution

★★★★★

3.33 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Creating a unique SQL database for a Travel Company 1 Database Creation CREATE DATABASE TravelCompany 2 Table Creation a Customers CREATE TABLE Custom... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....

Critically compare different data models and schemas Task 1.1 You are required to identify various types of database models such as hierarchical network relational and object-oriented. Use...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Protein Blenders, Inc., made a contract with Gingerich to buy from him the shares of stock of a small corporation. When the buyer refused to take and pay for the stock, Gingerich sued for specific...

Carvone is the major constituent of spearmint oil. What products would you expect from reaction of carvone with the following reagents? (a) (CH 3 ) 2 Cu ? Li + , then H 3 O + ? (b) LiAlH 4 , then H 3...

Visit Paytm.com, one of Indias largest growing payment and commerce companies. Research and share thoughts on how Paytm might be applying the six stages of Ladder of Customer Loyalty to drive their...

To what extent do you agree with the humanistic ideas, as stated by Abraham Maslow (1968), that our inner nature is good or neutral rather than bad and that if it is permitted to guide our life, we...

A motivational speaker claimed that wearing red on the day of an exam "energizes" the brain and improves performance. Your psychology professor doubts this is true. Design an experiment that would...

Required information [The following information applies to the questions displayed below] On January 1, 2024, the Allegheny Corporation purchased equipment for $187,000. The estimated service life of...

Stryker Corporation is a leading medical technology company headquartered in Kalamazoo, Michigan, that trades on the New York Stock Exchange. Following are selected financial data for Stryker for the...

Building which of the following is the least expensive path to creating a mobile presence? 1 point native app hybrid HTTP mobile web app mobile website

Read the following note on organisational resilience and on the basis of the motivation stipulated for the proposed study answer all questions that follow. Organisational Resilience 21st century...

You own a catering hall, and next Saturday, you have two events booked. At noon, you have a luncheon scheduled until 5:00, and then you have a Sweet 16 party, with guests scheduled to arrive at 7:00...

1. Explain the difference between manufacturing operations and service operations. 2. Provide a sample of a service organization. Reflection Activity R eflect by relating the university VMO with your...

Identity plays an important role in people's professions. In fact, people tend to derive a great deal of their identity from what they do. When some professions are identified as male and others as...

Scenario. Consider the following. FUN, a medium-sized (but rapidly expanding) INGO hires you to manage the organization's internal communications and external outreach initiatives. Based in...

The MindGineer Project for your organization has been assigned to you to oversee as the project manager. A completion budget of RM 1,500,000 and a 18-month timeline are set forth for this project....

In a nonmagnetic medium, E = 50 cos (10 9 t 8x) a y + 40 sin (10 9 t 8x) a z V/m find the dielectric constant r and the corresponding H.

I. Describe the purpose of PGP and its benefit of being a hybrid cryptosystem to storing and maintaining information. Note that this system uses some of the best available cryptographic algorithms to...

I. Explain how in a substitution cipher you substitute one value for another. II. Describe a type of substitution based on a monoalphabetic substitution and how it only uses one alphabet whereas a...

True or False: It is not necessary to have an alternate procedure in place in the event a lock fails because a door or access point will open automatically without any additional assistance.

The Baton Rouge Company compiled the following information for the current year related to its defined benefit pension plan: Present value of defined benefit obligation, beginning of year .....

On January 1, Year 1, the Hoverman Corporation made amendments to its defined benefit pension plan, resulting in $150,000 of past service costs. The plan has 100 active employees with an average...

On January 2, Year 1, Argy Company's board of directors granted 12,000 stock options to a select group of senior employees. The requisite service period is three years, with one-third of the options...