Answered step by step
Verified Expert Solution
Link Copied!

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 

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

Prove that if Σ an is absolutely convergent, then a. an

Answered: 1 week ago