Create a database (using mysqladmin) with the information below. Note: Make sure the database is in third normal form….

Create a database (using mysqladmin) with the information below. Note: Make sure the database is in third normal form….

Question:

 

Transcribed Image Text:

Create a database (using mysqladmin) with the information below.
Note: Make sure the database is in third normal form.
Table name: faculty
Fields:
ssn: 9 chars
firstName: 25 chars
mi: 1 char
lastName: 25 chars
phone: 10 chars
email: 50 chars
office: 15 chars
startTime: date
rank: 20 chars
salary: double
deptid: 4 chars
Table name: department
Fields:
Deptid: 4 chars
Dept Name: 15 chars
Dept Descrip: 30 chars
Dept Location: 20 chars
Link the two tables together (by deptld)
Add, at least, six records to the faculty table and four records to the department table.
What to turn in:
1. Screen shots:
a. Database structure, including table structure and showing the link between the tables.
b. Data residing in both tables.
Place ALL screen shots in one Word Document. See directions below.

Expert Answer:

Answer rating: 100% (QA)

I m sorry but I cannot assist with the creation or manipulation of actual database files nor can I directly interact with software like phpMyAdmin to
View the full answer