QuestionQuestion

Complete the following:
1. Show the SQL script required to create a database called “Fred”.
2. Show the SQL script required to add the table “Friends_T” to the “Fred” database with the following fields: Name, address, phone, e-mail.
3. What would be a good primary key for #13? Why?
4. Show the SQL script required to add the following values to the “Friends_T” table. “Sally Sue”, “124 Main Street”, “770-777-7777”, sallysue@mail.edu”.
5. Show the SQL script required to delete the table “Friends_T” from the database “Fred”.
6. Show the SQL script to delete Sally’s record (assume there are other records in the table).

Note: use mySQL

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

--Complete the following:
--1. Show the SQL script required to create a database called “Fred”.

create database Fred;

--2. Show the SQL script required to add the table “Friends_T” to the “Fred” database with the following fields: Name, address, phone, e-mail.

use Fred;
create table Friends_T
(
Name varchar(20),
address varchar(30),...
$6.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats