Question
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 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),...