Question: Create a database (using mysqladmin) with the information below. Note: Make sure the database is in third normal form. Table name: faculty Fields: ssn:

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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!