Question: You have been provided a SQL script containing data for a table called my_contacts . Import this data into a new database that you create

You have been provided a SQL script containing data for a table calledmy_contacts. Import this data into a new database that you create for the purpose of this assignment-name the database appropriately.Please include the add 10 more users to this table. Please devise fictitious contact information for this purpose please. Decide whether your import statement requires field mapping. If it does, include it, and if it does not, exclude it.

In themy_contactstable you will find two columns that are violating First Normal Form by storing multiple values within each column.

Use your knowledge of working with string values, multi-table operations and joins to extract the data frommy_contactsand store the data according to this schema; there is an ERD provided below to assist you.

Please establish appropriate composite primary IDs for the junction tables, and otherwise use the ERD should explain the primary and foreign keys that need to be established.

Please remove any empty/unwanted columns after you have completed your work

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

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...

Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...

Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.

Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...

Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Small Commuter Airline Reservation Database Create 2 new users statement for the database. One of...

Create a SQL script containing your data definition language (DDL) statements to create your tables, views, triggers, and other required database objects for your project. Your script must also...

Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Food Truck Company Database Create 2 new users statement for the database. One of the new user...

Start by creating an R Project and then within that project, create an R Program ( Script ) with the file name LastNameF.CRDB . CS 5 2 0 0 . R where LastName is your last name and F is your first...

The Entity - Relationship diagram above would translate to five relational tables: a . Asset _ Types categories of assets that employees may be assigned ( e . g . , Laptop, Desktop, Tablet ) b ....

I need help with the following attached assignment. Using the information provided in the Baseball Database documentation included in Module 1 , ( See the image below ) Baseball database...

Using Vogel's Approximation method, determine the minimum optimal transportation cost. Wheat is harvested in the Midwest of the USA and stored in grain elevators in four different citiesEvansville...

Ada Fontanez is the chief executive officer (CEO) of a large company that owns a chain of athletic shoe stores. The company was in dire financial condition when she was hired three years ago. To...

Planetary Travel Company has 1 3 9 , 0 0 0 , 0 0 0 . 0 0 in stockholder equity. Common stock is 3 0 , 0 0 0 , 0 0 0 and the balance is retained earnings. The firm has $ 2 7 0 0 0 0 0 0 0 . 0 0 in...

Impairments on December 31, 2010, Iva Majoli Company borrowed $62,092 from Paris Bank, signing a 5-year, $100,000 zero-interest-bearing note. The note was issued to yield 10% interest. Unfortunately,...

Figure shows a rigid assembly of a thin hoop (of mass m and radius R = 0.150 m) and a thin radial rod (of mass m and length L = 2.00R). The assembly is upright, but if we give it a slight nudge, it...

A summary of cash flows for Absolute Consulting Group for the year ended July 31, 2012, is shown below. Cash receipts: Cash received from customers$187,500 Cash received from issuing additional...

Two people, one of mass 75-kg and the other of mass 60kg, sit in a rowboat of mass 80kg. With the boat initially at rest, the two people, who have been sitting at opposite ends of the boat 3.2m apart...

In an absorption tower (or absorber), a gas is contacted with a liquid under conditions such that one or more species in the gas dissolve in the liquid. A stripping tower (or stripper) also involves...

ii. Rationale for Methods Aligning with Adult Learning Principles These methods leverage active participation, experiential learning, and self-directed study, which are proven to enhance retention...

What is a collection and what criteria are required to be met for a group of items to be defined as a collection?

Companies L and D both operate food processing plants, and both operate a chain of retail food stores. Company L transfers all of the output from its processing plants to its stores, while Company Ds...

What factors should be examined to determine whether significant influence exists?

36.Astore must decide whether or not to stock a new item. The decision depends on the reaction of consumers to the item, and the payoff table is as follows:

26. In Exercise 11, Chapter 8, the production manager must make an estimate of the mean weight of items turned out by the process in question. His loss function is linear with k0 = ku. What should...

29. For a sample of size one from a normal population with known variance 25, show that the classical test of Ho-n = 50 versus Hi./jl 60 with a .05 is a likelihood ratio test. That is, show that...