The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 2 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Need an SQL for Week 4 of DBM 380 for the University of Phoenix. The assignment is as follows:
The following assignment is based on the database environment designed in the Week Three Individual Assignment.
Your database project must meet the following assessment requirements:
Submit an .sql file with the scripts needed to create tables with keys and to insert test rows, etc., into the tables and submit to the Assignment Files tab.
Â
Individual Database NormalizationNicholas HenningDBM/380Bill EnloePARTS TRACKING 3NF NORMALIZATION1NF First Normal Form:Primary keyEMPLOYEE IDEMPLOYEE NAMESTATIONLOCATIONPARTNUMBERPARTSUPPLIERPARTCOSTPARTDESIGNATORSUPPLIERPHONE #005126James SmithTTR828-152-004Vishnay$25C1011-800-123-4567005128John SmithRDU828-111-003APC$30C5001-800-765-4321004141Maria GarciaDDP828-152-004Vishnay$25C1011-800-123-4567004111WilliamHernandezICC828-111-003APC$30C5001-800-765-4321004561AmandaReynoldsAFD828-115-002Digikey$28C2001-800-999-1111
Attachments:
-----------