Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started