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 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
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
Get step-by-step solutions from verified subject matter experts
