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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started