suppliers.sql
custumer.sql
employee
3. Create a table named employee with the following attributes, data types, and constraints: a. ID, integer, 7 characters, not null, auto increment b. lastName, variable character, 50 characters, not null c. firstName, variable character, 50 characters, not null d. address, variable character, 90 characters, not null e. city, variable character, 90 characters, not null f. state, character, 2 characters, not null g. zip Code, character, 5 characters, not null h. phone, character, 10 characters, not null i. email, variable character, 90 characters, not null, unique j. primary key is the ID field 4. Create a table named customer with the following attributes, data types, and constraints: a. ID, integer, 7 characters, not null, auto increment b. lastName, variable character, 50 characters, not null c. firstName, variable character, 50 characters, not null d. address, variable character, 90 characters, not null e. city, variable character, 90 characters, not null f. state, character, 2 characters, not null g. zip Code, character, 5 characters, not null h. phone, character, 10 characters, not null i. email, variable character, 90 characters, not null, unique j. primary key is the ID field 5. Create a table named supplier with the following attributes, data types, and constraint a. ID, integer, 7 characters, not null, auto increment b. supplierName, variable character, 50 characters, not null, unique c. address, variable character, 90 characters, not null d. city, variable character, 90 characters, not null e. state, character, 2 characters, not null f. zipCode, character, 5 characters, not null g. phone, character, 10 characters, not null h. email, variable character, 90 characters, not null, unique i. primary key is the ID field Order of data: supplierName, address, city, state, zipCode, phone, email */ New Direction Foods, 16321 Gothard St. Suite C-F, Huntington Beach, CA, 92647, 5626068511, info@new-direction-foods.com Monogram Foods, 530 Oak Court Drive Suite 400, Memphis, TN, 38117, 9016857167, info@monogram-foods.com Dutt and Wagner of Virginia, Inc, 1142 West Main Street, Abingdon, VA, 24210, 8006882116, info@dutt-wagner-virginia.com Culinary Specialties, Inc, 1231 Linda Vista Drive, San Marcos, CA, 92078, 7607448220, info@culinary-specialties.com John E. Koerner Company, 4820 Jefferson Hwy, Jefferson, LA, 70121, 8003331913, info@koerner-company.com Diversified Foods and Seasonings LLC, 1404 Greengate Drive Suite 300, Covington, LA, 70433, 8009142382, info@diversified-foods.com Ajinomoto Foods North America, 4200 Concours Street Suite 100, Ontario, CA, 91764, 9094774700, info@ajinomoto-foods-na.com Ascot Valley Foods, 205 Ascot Pkwy, Cuyahoga Falls, OH, 44223, 3303769411, info@ascotvalleyfoods.com Kellogg NA Company, P.O. Box CAMB, Battle Creek, MI, 49016, 8009621413, info@kelloggs.com AppetizersUSA, 15210 N. 75th Street Suite A, Scottsdale, AZ, 85260, 4804712601, info@appetizers-usa.com Order of data: last Name, first Name, address, city, state, zipcode, phone, email */ Goodman, Yvonne, 12 Creekside st, Nashville, TN, 37205, 2025550109, ygoodmanlisp.com Mackenzie, Dante, 137 wall st, Nashville, TN, 37295, 2925550112, dmackenzie@isp.com Rollins, Alysha, 411 Shirley St, Nashville, TN, 37205, 2025550115, arollinsoisp.com Gonzalez, Avaya, 7771 Border Court, Nashville, TN, 37285, 2825550119, agonzalez@isp.com Kelly, Haniya, 6 South Sulphur Springs Street, Nashville, TN, 37205, 2025550121, hkelly@isp.com Chambers, Nathalie, 942 New Saddle Drive, Clover, SC, 29719, 2825550122, nchambers@isp.com Rollins, Dante, 9 Wrangler Ave, Clover, sc, 29710, 2825550124, drollins isp.com Mckee, Beverley, 7319 S. Greenview Drive, Clover, sc, 29710, 2025550125, bmckeemisp.com Lindsey, Paris, 763 West Mulberry St, Clover, SC, 29710, 2025550132, plindsey@isp.com Melia, Umaiza, 545 Ohio Ave, Clover, SC, 2971e, 2025550135, umelia@isp.com Prince, Nico, 20 Middle River Street, Willoughby, OH, 44094, 2925550137, nprincebisp.com Rennie, Javan, 8112 North Country St, Willoughby, OH, 44094, 2925550139, Jrennie@isp.com Waters, Ali, 83 Rockland Lane, Willoughby, OH, 44094, 2925550144, awaters isp.com Clarke, Johnpaul, 1 Riverside Lane, Willoughby, OH, 44094, 2025558153, jpcclarke@isp.com Kaiser, Dane, 694 wall Road, Willoughby, OH, 44894, 2025550155, kdaiserQisp.com Newman, Hammad, 9970 State Court, Duluth, GA, 30096, 2025558157, hnewman@isp.com Guthrie, Maha, 54 Woodsman Drive, Duluth, GA, 30096, 2925550161, mguthrielisp.com Roberts, Tulisa, 7174 Studebaker Street, Duluth, GA, 30096, 2025550163, troberts@isp.com Solis, Robin, 8474 Wentworth Street, Duluth, GA, 30096, 2925550164, rsolisisp.com Heath, Kavita, 796 Hartford St, Duluth, GA, 30896, 2025550165, kheath isp.com White, Meera, 484 Bridge St, Piscataway, NJ, 88854, 2925550166, mwhite isp.com Esparza, Bradlee, 7031 Gainsway St, Piscataway, NJ, 08854, 2025550173, besparza isp.com Order of data: lastName, firstName, address, city, state, zipcode, phone, email Prince, Yvonne, 12 Creekside St, Huntington Beach, CA, 92647, 2025550109, yprince@frozenfoods.com Rennie, Dante, 137 wall st, Memphis, TN, 38117, 2025550112, drennie@frozenfoods.com Waters, Alysha, 411 Shirley St, Abingdon, VA, 24210, 2025550115, awaters@frozenfoods.com Clarke, Avaya, 7771 Border Court, San Marcos, CA, 92078, 2025550119, aclarke@frozenfoods.com Kaiser, Haniya, 6 South Sulphur Springs Street, Jefferson, LA, 70121, 2025550121, hkaiser@frozenfoods.com Newman, Nathalie, 942 New Saddle Drive, Covington, LA, 70433, 2025550122, nnewman@frozenfoods.com Guthrie, Dante, 9 Wrangler Ave, Ontario, CA, 91764, 2025550124, dguthrie@frozenfoods.com Roberts, Beverley, 7319 S. Greenview Drive, cuyanoga Falls, OH44223, 2025550125, broberts@frozenfoods.com Solis, Paris, 763 West Mulberry St, Battle Creek, MI, 49016, 2025550132, psolis@frozenfoods.com Heath, Umaiza, 545 Ohio Ave, Scottsdale, AZ, 85260, 2025550135, uheath@frozenfoods.com
