Design AND create a small database in MYSQL to store the $first_Name, $last_Name
ID: 3533859 • Letter: D
Question
Design AND create a small database in MYSQL to store the $first_Name, $last_Name, $email_address, and $date.
- at least 5 tables
- should be in 5th Normal Form (5NF)
- should include one all refrence table
** Visual depiction should display all tables, column names, and primary/foreign key links.
Necessary files available upon request.
Explanation / Answer
mysql> CREATE DATABASE `registration`;CREATE TABLE `registration` ( `first name` VARCHAR(200), `last name` VARCHAR(100) `email` VARCHAR(50) NOT NULL ,PRIMARY KEY (`id`), `date` DATE,'occupation'VARCHAR(200), `address` VARCHAR(20));INSERT INTO `registration` (`first name`, `last name`,'email','address')VALUES ('Peter', 'Temple','masmile@gmail.com',jamshedpur),CREATE TABLE `address` ( `location` VARCHAR(200), `city` VARCHAR(100) , `state` VARCHAR(50),'phoneno' DECIMAL(10) NOT NULL ,PRIMARY KEY (`id`),'pincode' DECIMAL(13));CREATE TABLE `occupation` ( `government` VARCHAR(200), `private` VARCHAR(100) ','location'VARCHAR(100)','phone no' DECIMAL(10) NOT NULL ,PRIMARY KEY (`id`));