I need some help on this project. Some detailed steps would muchbe appreciated!
Deliverable 1. Table Creation Using ERwin and Microsoft SQL Server, create the tables and populate them with data. The source of your data will be the Microsoft Excel spreadsheet provided to you on the Blackboard assignment. You should realize that the spreadsheet is poorly designed, and you will need to normalize the data to populate your tables. A. Use ERwin to create the tables, and then forward engineer them to automatically generate the schema in SQL Server. Include your .erwin file with your deliverables, as well as your SQL database. NOTE: your database and ERwin files must be named using the syntax of LASTNAMEF-P3 (where F is your first initial and P3 represents Project 3). Reminder: To obtain your SQL database file, first make sure that there are no open connections to your SQL database (either your Query Session or ERwin), then right-click on your database and select the detach menu option. Detaching your database will produce two output files, ( .mdf & .ldf). Both are necessary to attach a database, so be sure to include both Here is list of the entities for this project: Entities: CUSTOMER_T (PK) CustomerID CustomerName CustomerStreet CustomerCity CustomerState CustomerZip CreditLimit SalesReplD (FK) of EMPLOYEE_T ORDER_T OrderlD (PK) (FK) of CUSTOMER_T CustomerID CustomerPONumber (This means the Customer Purchase Order Number) OrderDate DueDate ShipDate ORDER_LINE_T OrderID composite (PK), (FK) of ORDER_T composite (PK), (FK) of PRODUCT_T ProductID OrderQuantity PRODUCT_T ProductID (PK) ProductDescription UnitPrice StockQuantity this is the amount of the product we have in our warehouse. It is not provided in the data, so make up an arbitrary amount. FABRICATED_T composite (PK), (FK) of PRODUCT_T.Product I D composite(PK), (FK) of PRODUCT_T.Productl D quantity of Part|D that goes into ProductID (example, 2 tires In one bicycle) ProductID PartID PartQuantity PRODUCT_SUPPLIER_T composite (PK), (FK) of PRODUCT_T composite (PK), (FK) of SUPPLIER_T this is the ID the Vendor (i.e., Supplier) uses in their system), similar to Customer PONumber in the ORDER_t. this is the amount we paid the Vendor for the product ProduclD SupplierID VendorPartID ProductCost PurchasedQuantity SUPPLIER_T SupplierID SupplierName SupplierStreet SupplierCity SupplierState SupplierZip (РК) EMPLOYEE_T (РК) EmployeelD EmployeeFirst Name EmployeeLastName EmployeeJobTitle EmployeeStreet EmployeeCity EmployeeState EmployeeZip EmployeeHireDate ManagerID (FK) unary EMPLOYEE_COURSE_T EmployeelD composite (PK), (FK) of EMPLOYEE_T composite (PK), (FK) of COURSE_T CourselD CompletionDate COURSE_T (PK) CourseDescription CourselD SALES_REPRESENTATIVE_T EmployeelD CommissionRate (hint: only employees with commission rates should be added to this table) (PK), (FK) of EMPLOYEE_T B. Be sure to include the appropriate integrity constraints and the proper data types and field widths. C. Populate the tables using SQL statements within SQL Server. Include a screenshot of successfully populating at least one row in each table with your deliverables. Provide the results of the INSERT INTO screenshots with one table per page. I strongly suggest that you save all of your INSERT INTO statements in a text file. By doing this, if you ever need to rebuild your database, it will not take long to add your data. I suspect that you will wish that you have this text file when you work on Project 3 in the future. CustomerCity CustomerState CustomerZip CreditLimit CustSalesRep OrderID OrderQTY ProductID ProdDesc UnitPrice StockQTY CustPONumber OrderDate OrderDueDate OrderShipDate CustomerID CustomerName CustomerStreet 3000 Large Sterilizer 120,000.00 5000 Security System $ 90048 $100,000.00 Louis Stein 10/18/2018 0:00 10/25/2018 0:00 10/25/2018 0:00 1 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD 8700 BEVERLY BLVD RM A 845 LOS ANGELES CA 1001 1 10 PO# 189931 90048 $100,000.00 Louis Stein 11/5/2018 0:0o 11/13/2018 0:00 11/15/2018 0:00 1 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD 8700 BEVERLY BLVD RM A 845 LOS ANGELES CA 1010 1 10,000.00 2 PO# 498998 LOS ANGELES 90230 $100,000.00 Christopher Demanby 90503 35,000.00 Travis Hall 90210 35,000.00 Kyle Sica 4000 Hospital Bed 4000 Hospital Bed 10/24/2018 0:00 11/1/2018 0:00 11/3/2018 0:00 2 VENICE BEACH SURGICAL CENTER 11961 VENICE BLVD CA 1006 3 70,000.00 10 PO# 111825 10 PO# 576209 3 R AND R SURGICAL INSTITUTE 70,000.00 10/24/2018 0:00 11/1/2018 0:00 11/1/2018 0:00 21250 HAWTHORNE BLVD STE 430 TORRANCE CA 1005 BEVERLY HILLS 1009 2000 Small Sterilizer $ 85,000.00 11/5/2018 0:00 11/13/2018 0:00 11/13/2018 0:00 4 OUTPATIENT SURGERY CENTER OF BEVERLY HILLS 433 N CAMDEN DR STE 1170 GHAVAMI ASHKAN CA 20 PO# 431627 LOS ANGELES 90024 $400,000.00 Louis Stein 3000 Large Sterilizer $ 120,000.00 10 PO# 100420 10/22/2018 0:00 10/30/2018 0:00 10/30/2018 0:00 5 CENTER FOR AMBULANCE SURGERY TREATMENT 1090 GLENDON AVE CA 1004 4 INGLEWOOD 90301 $100,000.00 Christopher Demanby 2000 Small Sterilizer $ 20 PO# 515090 10/18/2018 0:00 10/26/2018 0:00 10/26/2018 0:00 8 CENTINELA HOSPITAL MEDICAL CENTER 931 S FLOWER ST CA 1002 85,000.00 90242 $100,00o.00 Marlyce Bauer 1000 Power Generator $ 50,00o.00 5 PO# 937052 12/4/2018 0:00 12/12/2018 0:00 12/12/2018 0:00 9 RANCHO LOS AMIGOS MEDICAL CENTER 7601 IMPERIAL HWY DOWNEY CA 1012 2 5000 Security System $ 10,000.00 SANTA MONICA CA 90401 $100,00o.00 William Medeiros 10/27/2018 0:00 11/4/2018 0:00 11/4/2018 0:00 11 YOUNIQUE SURGERY CENTER AND MEDICAL SPA 1551 OCEAN AVE STE 200 1007 1 2 PO# 164241 SAN PEDRO 90732 $100,000.00 Kyle Sica 2000 Small Sterilizer $ 85,000.00 10/30/2018 0:00 11/7/2018 0:00 11/7/2018 0:00 12 PROVIDENCE MEDICAL CENTER SAN PEDRO 1300 W 7TH ST CA 1008 2 20 PO# 197871 25825 VERMONT AVE HARBOR CITY 90710 $400,000.00 Travis Hall 2000 Small Sterilizer $ 20 PO# 123489 10/22/2018 0:00 10/30/2018 0:00 10/30/2018 0:00 15 KAISER-PERMANENTE CA 1003 1 85,000.00 3000 Large Sterilizer 90210 $100,000.00 Kyle Sica 120,000.00 10 PO# 202632 11/15/2018 0:00 11/23/2018 0:00 11/23/2018 0:00 20 BEDFORD SURGI CENTER 436 N BEDFORD DR STE 218 BEVERLY HILLS CA 1011 1 90716 $100,000.00 6 GARDENS REGIONAL HOSPITAL AND MEDICAL 21530 PIONEER BLVD ONCOLOGY FHP ONCOLOGY HAWAIIAN GARD CA BELLFLOWER 9400 ROSECRANS AVE 90706 $100,000.00 7 KAISER BELLFLOWER MED CENTER CA 90059 $100,000.00 10 MARTIN LUTHER KING JUNIOR COMMUNITY HOS 1680 E 120TH ST LOS ANGELES CA 90033 $100,000.00 1510 SAN PABLO ST 13 USC CARE LOS ANGELES CA 90505 $100,000.00 14 COAST SURGERY CENTER OF SOUTHBAY 3445 PACIFIC COAST HWY STE 110 TORRANCE CA 90255 $100,000.00 90015 $100,000.00 16 COMMUNITY HOSPITAL HUNTINGTON 2623 E SLAUSON AVE HUNTINGTON PACA 17 CALIFORNIA HOSPITAL AND MEDICAL CENTER 1401 S GRAND AVE LOS ANGELES CA 701 E 28TH ST STE 300 90806 $100,000.00 18 SAINT MICHAEL SURGERY CENTER LONG BEACH CA 90033 $100,000.00 19 WHITE MEMORIAL MEDICAL CENTER 1723 MICHIGAN AVE LOS ANGELES CA CourselD Course Description 100 Integrity Selling EmpState EmpZip EmpHireDate Commission Rate 11/3/2015 CourseCompletionDate EmployeelD EmpFirstName EmplastName EmpJobTitle EmpStreet EmpCity EmployeeManager 2/8/2016 SalesRep 15% Michael Carboni 1 William Medeiros 3210 W. Parkland Blvd. Tampa FL 33609 5/18/2016 11/3/2015 1 William Medeiros SalesRep 3210 W, Parkland Blvd. 15% Michael Carboni 200 Hospital Infrastructure Introduction Tampa FL 33609 201 Hospital Infrastructure Advanced 202 Sterilization Product Training 5/19/2016 11/3/2015 1 William Medeiros SalesRep 3210 W. Parkland Blvd. 15% Michael Carboni Tampa FL 33609 5/20/2016 SalesRep 3210 W. Parkland Blvd. 11/3/2015 1 William Medeiros Tampa 15% Michael Carboni FL 33609 203 Power Systems Training 5/21/2016 11/3/2015 1 William Medeiros SalesRep 3210 W. Parkland Blvd. 15% Michael Carboni Tampa FL 33609 101 Coaching & Developing a Team 100 Integrity Selling 2/9/2012 Carboni 6/19/2008 1/13/2011 2 Michael SalesManager 98 Waldo Ave Rochester Bill Gates NY 14609 з Кyle з Kyle з Kyle 4/22/2011 SalesRep Whitestown 20% Jamie Zwolinski Sica 6293 Primrose Drive IN 46075 7/31/2011 SalesRep 1/13/2011 Whitestown 20% Jamie Zwolinski 200 Hospital Infrastructure Introduction Sica 6293 Primrose Drive IN 46075 8/1/2011 SalesRep 1/13/2011 201 Hospital Infrastructure Advanced Whitestown 20% Jamie Zwolinski Sica 6293 Primrose Drive IN 46075 1/13/2011 202 Sterilization Product Training 8/2/2011 SalesRep Whitestown 3 Kyle 20% Jamie Zvwolinski Sica 6293 Primrose Drive IN 46075 20% Jamie Zvwolinski з Kyle 8/3/2011 1/13/2011 203 Power Systems Training 100 Integrity Selling 200 Hospital Infrastructure Introduction SalesRep 6293 Primrose Drive Whitestown Sica IN 46075 4/13/2018 SalesRep 1/3/2018 4 Louis 7707 Copper Cave 17% Michael Carboni Stein San Antonio TX 78249 7/22/2018 SalesRep 7707 Copper Cave 1/3/2018 4 Louis 17% Michael Carboni Stein San Antonio TX 78249 7/23/2018 1/3/2018 17% Michael Carboni 201 Hospital Infrastructure Advanced 4 Louis Stein SalesRep San Antonio 7707 Copper Cave TX 78249 1/3/2018 202 Sterilization Product Training 7/24/2018 SalesRep 7707 Copper Cave 17% Michael Carboni 4 Louis Stein San Antonio TX 78249 203 Power Systems Training 7/25/2018 SalesRep 1/3/2018 17% Michael Carboni 4 Louis Stein 7707 Copper Cave San Antonio TX 78249 6/9/2017 5 Christopher Demanby SalesRep 3/1/2017 100 Integrity Selling 4 Magnolia Drive 11% Michael Carboni Saratoga Springs NY 12866 3/1/2017 200 Hospital Infrastructure Introduction 9/17/2017 5 Christopher 5 Christopher 5 Christopher 5 Christopher 11% Michael Carboni Demanby SalesRep 4 Magnolia Drive 12866 Saratoga Springs NY 9/18/2017 Demanby 4 Magnolia Drive 3/1/2017 SalesRep Saratoga Springs 11% Michael Carboni 201 Hospital Infrastructure Advanced NY 12866 9/19/2017 3/1/2017 202 Sterilization Product Training Demanby SalesRep 4 Magnolia Drive Saratoga Springs 11% Michael Carboni NY 12866 203 Power Systems Training 9/20/2017 Saratoga Springs Seattle 3/1/2017 Demanby SalesRep 4 Magnolia Drive 11% Michael Carboni NY 12866 100 Integrity Selling 6/12/2014 3/3/2014 8% Michael Carboni 6 Marlyce SalesRep 2466 24th Ave E Bauer WA 98112 9/20/2014 SalesRep 3/3/2014 200 Hospital Infrastructure Introduction 6 Marlyce 6 Marlyce 2466 24th Ave E Seattle 98112 8% Michael Carboni Bauer WA 9/21/2014 SalesRep Seattle 3/3/2014 201 Hospital Infrastructure Advanced 2466 24th Ave E 8% Michael Carboni Bauer WA 98112 202 Sterilization Product Training 9/22/2014 6 Marlyce 2466 24th Ave E 3/3/2014 8% Michael Carboni SalesRep Seattle Bauer WA 98112 3/3/2014 9/23/2014 203 Power Systems Training 6 Marlyce SalesRep 2466 24th Ave E Seattle 8% Michael Carboni Bauer WA 98112 4/30/2016 8/8/2016 SalesRep 1/19/2016 100 Integrity Selling 200 Hospital Infrastructure Introduction Hall 47 Moody Avenue clovis 10% Jamie Zwolinski 7 Travis СА 93619 10% Jamie Zwolinski SalesRep 47 Moody Avenue 1/19/2016 1/19/2016 7 Travis Hall Clovis CA 93619 201 Hospital Infrastructure Advanced 202 Sterilization Product Training 8/9/2016 47 Moody Avenue Hall SalesRep Clovis 10% Jamie Zwolinski 7 Travis СА 93619 8/10/2016 1/19/2016 7 Travis Hall SalesRep SalesRep 47 Moody Avenue Clovis 10% Jamie Zwolinski СА 93619 8/11/2016 1/19/2016 203 Power Systems Training Hall 47 Moody Avenue clovis 10% Christopher Hudnut 7 Travis CA 93619 4/23/2011 257 Mallorca Way 1/31/2010 101 Coaching & Developing a Team 8 Jamie Zwolinski SalesManager San Francisco Bill Gates CA 94123 3/4/2013 100 Integrity Selling 6/15/2013 9 Christopher 9 Christopher 9 Christopher 29835 Buffalo Canyon Dr Hudnut SalesRep 77386 10% Jamie Zwolinski Spring TX 9/23/2013 9/24/2013 SalesRep 29835 Buffalo Canyon Dr 3/4/2013 200 Hospital Infrastructure Introduction Hudnut Spring 10% Jamie Zwolinski TX 77386 3/4/2013 29835 Buffalo Canyon Dr Hudnut SalesRep 10% Jamie Zwolinski 201 Hospital Infrastructure Advanced Spring TX 77386 202 Sterilization Product Training 8/10/2016 SalesRep 1/19/2016 Hall 47 Moody Avenue Clovis 93619 10% Jamie Zwolinski 7 Travis CA 203 Power Systems Training 8/11/2016 Clovis 1/19/2016 Hall SalesRep 47 Moody Avenue 257 Mallorca Way 93619 10% Christopher Hudnut 7 Travis CA 1/31/2010 3/4/2013 3/4/2013 Zwolinski 4/23/2011 101 Coaching & Developing a Team SalesManager Bill Gates 8 Jamie San Francisco CA 94123 6/15/2013 29835 Buffalo Canyon Dr 100 Integrity Selling 9 Christopher Hudnut SalesRep Spring 10% Jamie Zwolinski TX 77386 9/23/2013 9 Christopher 9 Christopher SalesRep 29835 Buffalo Canyon Dr 10% Jamie Zwolinski 200 Hospital Infrastructure Introduction Hudnut Spring TX 77386 201 Hospital Infrastructure Advanced 202 Sterilization Product Training 9/24/2013 9/25/2013 SalesRep 29835 Buffalo Canyon Dr 3/4/2013 Hudnut 77386 10% Jamie Zwolinski Spring TX 3/4/2013 29835 Buffalo Canyon Dr 9 Christopher Hudnut SalesRep Spring 10% Jamie Zwolinski TX 77386 203 Power Systems Training 9/26/2013 29835 Buffalo Canyon Dr 3/4/2013 9 Christopher Hudnut SalesRep Spring 77386 10% Jamie Zvwolinski TX 100 Integrity Selling 11/13/2016 8/1/2016 10 Magdalena Мaxwell SalesRep 384 North Road Chester 15% Jamie Zwolinski NJ 7930 2/21/2017 10 Magdalena Maxwell SalesRep 8/1/2016 200 Hospital Infrastructure Introduction 384 North Road Chester 15% Jamie Zwolinski NJ 7930 8/1/2016 2/22/2017 201 Hospital Infrastructure Advanced 10 Magdalena Мaxwell SalesRep 384 North Road Chester 15% Jamie Zwolinski NJ 7930 202 Sterilization Product Training 2/23/2017 8/1/2016 10 Magdalena SalesRep 384 North Road Chester 15% Jamie Zwolinski Маxwell NJ 7930 203 Power Systems Training 2/24/2017 SalesRep Chester 8/1/2016 10 Magdalena Maxwell 384 North Road 15% Jamie Zwolinski NJ 7930 4/2/2018 1/1/2018 101 Coaching & Developing a Team 11 Bill VP of Sales Portland Bill Gates Gates 123 Easy Street OR ProductID Prod Desc UnitPrice InStockQTY SupplierID VendorPartlD SupplierName SupplierStreet SupplierCity SupplierStateSupplierZij ProductCost PurchasedQuantity GE INC 45066 25,000.00 $ 5.00 1000 Power Generator 50,000.00 3 PWR01 265 PIONEER BLVD SPRINGBORO OH 10 70584 S50,000.00 2000 Small Sterilizer 1 STO01 85,000.00 20.00 LA WHOLESALE INC. 301 HWY 167 N SUNSET LA 30 70584 70,000.00 $ 120,000.00 1 STO02 3000 Large Sterilizer 10.00 LA WHOLESALE INC. 301 HWY 167 N SUNSET LA 10 48375 $ 40,000.00 $ 4000 Hospital Bed 70,000.00 10.00 2 BD01 MEDLINE SUPPLY 43155 W 9 MILE RD DETROIT MI 20 5000 Security System $ 2.00 10,000.00 PartsRequired (QTY PartUnitPrice Part_StockQTY 2 5,000.00 1 8,000.00 ProductID ProductDesc PartID PartDesc 1000 Power Generato 1000 Power Generato 1000 Power Generato 110 Power Inverter 0 120 Diesel Engine 0 130 Generator Assembly Kit 1 4,000.00 0 1 3,000.00 4000 Hospital Bed 410 Bed Frame 0 8 $ 4000 Hospital Bed 420 Electric Motor 50.00 0 2 $ 4000 Hospital Bed 430 Control Panel 100.00 0 8 $ 4000 Hospital Bed 440 Wheel 5.00 0 1 2,000.00 5000 Security System 5000 Security System 5000 Security System 5000 Security System 510 Server 0 4 $ 520 Monitor – HD 300.00 0 20 $ 530 Camera Nightvision 4K 500.00 0 540 Camera Cable (in Feet) 500 $ 1.00 0 Show transcribed image text Deliverable 1. Table Creation Using ERwin and Microsoft SQL Server, create the tables and populate them with data. The source of your data will be the Microsoft Excel spreadsheet provided to you on the Blackboard assignment. You should realize that the spreadsheet is poorly designed, and you will need to normalize the data to populate your tables. A. Use ERwin to create the tables, and then forward engineer them to automatically generate the schema in SQL Server. Include your .erwin file with your deliverables, as well as your SQL database. NOTE: your database and ERwin files must be named using the syntax of LASTNAMEF-P3 (where F is your first initial and P3 represents Project 3). Reminder: To obtain your SQL database file, first make sure that there are no open connections to your SQL database (either your Query Session or ERwin), then right-click on your database and select the detach menu option. Detaching your database will produce two output files, ( .mdf & .ldf). Both are necessary to attach a database, so be sure to include both Here is list of the entities for this project: Entities: CUSTOMER_T (PK) CustomerID CustomerName CustomerStreet CustomerCity CustomerState CustomerZip CreditLimit SalesReplD (FK) of EMPLOYEE_T ORDER_T OrderlD (PK) (FK) of CUSTOMER_T CustomerID CustomerPONumber (This means the Customer Purchase Order Number) OrderDate DueDate ShipDate ORDER_LINE_T OrderID composite (PK), (FK) of ORDER_T composite (PK), (FK) of PRODUCT_T ProductID OrderQuantity
PRODUCT_T ProductID (PK) ProductDescription UnitPrice StockQuantity this is the amount of the product we have in our warehouse. It is not provided in the data, so make up an arbitrary amount. FABRICATED_T composite (PK), (FK) of PRODUCT_T.Product I D composite(PK), (FK) of PRODUCT_T.Productl D quantity of Part|D that goes into ProductID (example, 2 tires In one bicycle) ProductID PartID PartQuantity PRODUCT_SUPPLIER_T composite (PK), (FK) of PRODUCT_T composite (PK), (FK) of SUPPLIER_T this is the ID the Vendor (i.e., Supplier) uses in their system), similar to Customer PONumber in the ORDER_t. this is the amount we paid the Vendor for the product ProduclD SupplierID VendorPartID ProductCost PurchasedQuantity SUPPLIER_T SupplierID SupplierName SupplierStreet SupplierCity SupplierState SupplierZip (РК) EMPLOYEE_T (РК) EmployeelD EmployeeFirst Name EmployeeLastName EmployeeJobTitle EmployeeStreet EmployeeCity EmployeeState EmployeeZip EmployeeHireDate ManagerID (FK) unary EMPLOYEE_COURSE_T EmployeelD composite (PK), (FK) of EMPLOYEE_T composite (PK), (FK) of COURSE_T CourselD CompletionDate
COURSE_T (PK) CourseDescription CourselD SALES_REPRESENTATIVE_T EmployeelD CommissionRate (hint: only employees with commission rates should be added to this table) (PK), (FK) of EMPLOYEE_T B. Be sure to include the appropriate integrity constraints and the proper data types and field widths. C. Populate the tables using SQL statements within SQL Server. Include a screenshot of successfully populating at least one row in each table with your deliverables. Provide the results of the INSERT INTO screenshots with one table per page. I strongly suggest that you save all of your INSERT INTO statements in a text file. By doing this, if you ever need to rebuild your database, it will not take long to add your data. I suspect that you will wish that you have this text file when you work on Project 3 in the future.
CustomerCity CustomerState CustomerZip CreditLimit CustSalesRep OrderID OrderQTY ProductID ProdDesc UnitPrice StockQTY CustPONumber OrderDate OrderDueDate OrderShipDate CustomerID CustomerName CustomerStreet 3000 Large Sterilizer 120,000.00 5000 Security System $ 90048 $100,000.00 Louis Stein 10/18/2018 0:00 10/25/2018 0:00 10/25/2018 0:00 1 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD 8700 BEVERLY BLVD RM A 845 LOS ANGELES CA 1001 1 10 PO# 189931 90048 $100,000.00 Louis Stein 11/5/2018 0:0o 11/13/2018 0:00 11/15/2018 0:00 1 CEDARS-SINAI MEDICAL CENTER 8700 BEVERLY BLVD 8700 BEVERLY BLVD RM A 845 LOS ANGELES CA 1010 1 10,000.00 2 PO# 498998 LOS ANGELES 90230 $100,000.00 Christopher Demanby 90503 35,000.00 Travis Hall 90210 35,000.00 Kyle Sica 4000 Hospital Bed 4000 Hospital Bed 10/24/2018 0:00 11/1/2018 0:00 11/3/2018 0:00 2 VENICE BEACH SURGICAL CENTER 11961 VENICE BLVD CA 1006 3 70,000.00 10 PO# 111825 10 PO# 576209 3 R AND R SURGICAL INSTITUTE 70,000.00 10/24/2018 0:00 11/1/2018 0:00 11/1/2018 0:00 21250 HAWTHORNE BLVD STE 430 TORRANCE CA 1005 BEVERLY HILLS 1009 2000 Small Sterilizer $ 85,000.00 11/5/2018 0:00 11/13/2018 0:00 11/13/2018 0:00 4 OUTPATIENT SURGERY CENTER OF BEVERLY HILLS 433 N CAMDEN DR STE 1170 GHAVAMI ASHKAN CA 20 PO# 431627 LOS ANGELES 90024 $400,000.00 Louis Stein 3000 Large Sterilizer $ 120,000.00 10 PO# 100420 10/22/2018 0:00 10/30/2018 0:00 10/30/2018 0:00 5 CENTER FOR AMBULANCE SURGERY TREATMENT 1090 GLENDON AVE CA 1004 4 INGLEWOOD 90301 $100,000.00 Christopher Demanby 2000 Small Sterilizer $ 20 PO# 515090 10/18/2018 0:00 10/26/2018 0:00 10/26/2018 0:00 8 CENTINELA HOSPITAL MEDICAL CENTER 931 S FLOWER ST CA 1002 85,000.00 90242 $100,00o.00 Marlyce Bauer 1000 Power Generator $ 50,00o.00 5 PO# 937052 12/4/2018 0:00 12/12/2018 0:00 12/12/2018 0:00 9 RANCHO LOS AMIGOS MEDICAL CENTER 7601 IMPERIAL HWY DOWNEY CA 1012 2 5000 Security System $ 10,000.00 SANTA MONICA CA 90401 $100,00o.00 William Medeiros 10/27/2018 0:00 11/4/2018 0:00 11/4/2018 0:00 11 YOUNIQUE SURGERY CENTER AND MEDICAL SPA 1551 OCEAN AVE STE 200 1007 1 2 PO# 164241 SAN PEDRO 90732 $100,000.00 Kyle Sica 2000 Small Sterilizer $ 85,000.00 10/30/2018 0:00 11/7/2018 0:00 11/7/2018 0:00 12 PROVIDENCE MEDICAL CENTER SAN PEDRO 1300 W 7TH ST CA 1008 2 20 PO# 197871 25825 VERMONT AVE HARBOR CITY 90710 $400,000.00 Travis Hall 2000 Small Sterilizer $ 20 PO# 123489 10/22/2018 0:00 10/30/2018 0:00 10/30/2018 0:00 15 KAISER-PERMANENTE CA 1003 1 85,000.00 3000 Large Sterilizer 90210 $100,000.00 Kyle Sica 120,000.00 10 PO# 202632 11/15/2018 0:00 11/23/2018 0:00 11/23/2018 0:00 20 BEDFORD SURGI CENTER 436 N BEDFORD DR STE 218 BEVERLY HILLS CA 1011 1 90716 $100,000.00 6 GARDENS REGIONAL HOSPITAL AND MEDICAL 21530 PIONEER BLVD ONCOLOGY FHP ONCOLOGY HAWAIIAN GARD CA BELLFLOWER 9400 ROSECRANS AVE 90706 $100,000.00 7 KAISER BELLFLOWER MED CENTER CA 90059 $100,000.00 10 MARTIN LUTHER KING JUNIOR COMMUNITY HOS 1680 E 120TH ST LOS ANGELES CA 90033 $100,000.00 1510 SAN PABLO ST 13 USC CARE LOS ANGELES CA 90505 $100,000.00 14 COAST SURGERY CENTER OF SOUTHBAY 3445 PACIFIC COAST HWY STE 110 TORRANCE CA 90255 $100,000.00 90015 $100,000.00 16 COMMUNITY HOSPITAL HUNTINGTON 2623 E SLAUSON AVE HUNTINGTON PACA 17 CALIFORNIA HOSPITAL AND MEDICAL CENTER 1401 S GRAND AVE LOS ANGELES CA 701 E 28TH ST STE 300 90806 $100,000.00 18 SAINT MICHAEL SURGERY CENTER LONG BEACH CA 90033 $100,000.00 19 WHITE MEMORIAL MEDICAL CENTER 1723 MICHIGAN AVE LOS ANGELES CA
CourselD Course Description 100 Integrity Selling EmpState EmpZip EmpHireDate Commission Rate 11/3/2015 CourseCompletionDate EmployeelD EmpFirstName EmplastName EmpJobTitle EmpStreet EmpCity EmployeeManager 2/8/2016 SalesRep 15% Michael Carboni 1 William Medeiros 3210 W. Parkland Blvd. Tampa FL 33609 5/18/2016 11/3/2015 1 William Medeiros SalesRep 3210 W, Parkland Blvd. 15% Michael Carboni 200 Hospital Infrastructure Introduction Tampa FL 33609 201 Hospital Infrastructure Advanced 202 Sterilization Product Training 5/19/2016 11/3/2015 1 William Medeiros SalesRep 3210 W. Parkland Blvd. 15% Michael Carboni Tampa FL 33609 5/20/2016 SalesRep 3210 W. Parkland Blvd. 11/3/2015 1 William Medeiros Tampa 15% Michael Carboni FL 33609 203 Power Systems Training 5/21/2016 11/3/2015 1 William Medeiros SalesRep 3210 W. Parkland Blvd. 15% Michael Carboni Tampa FL 33609 101 Coaching & Developing a Team 100 Integrity Selling 2/9/2012 Carboni 6/19/2008 1/13/2011 2 Michael SalesManager 98 Waldo Ave Rochester Bill Gates NY 14609 з Кyle з Kyle з Kyle 4/22/2011 SalesRep Whitestown 20% Jamie Zwolinski Sica 6293 Primrose Drive IN 46075 7/31/2011 SalesRep 1/13/2011 Whitestown 20% Jamie Zwolinski 200 Hospital Infrastructure Introduction Sica 6293 Primrose Drive IN 46075 8/1/2011 SalesRep 1/13/2011 201 Hospital Infrastructure Advanced Whitestown 20% Jamie Zwolinski Sica 6293 Primrose Drive IN 46075 1/13/2011 202 Sterilization Product Training 8/2/2011 SalesRep Whitestown 3 Kyle 20% Jamie Zvwolinski Sica 6293 Primrose Drive IN 46075 20% Jamie Zvwolinski з Kyle 8/3/2011 1/13/2011 203 Power Systems Training 100 Integrity Selling 200 Hospital Infrastructure Introduction SalesRep 6293 Primrose Drive Whitestown Sica IN 46075 4/13/2018 SalesRep 1/3/2018 4 Louis 7707 Copper Cave 17% Michael Carboni Stein San Antonio TX 78249 7/22/2018 SalesRep 7707 Copper Cave 1/3/2018 4 Louis 17% Michael Carboni Stein San Antonio TX 78249 7/23/2018 1/3/2018 17% Michael Carboni 201 Hospital Infrastructure Advanced 4 Louis Stein SalesRep San Antonio 7707 Copper Cave TX 78249 1/3/2018 202 Sterilization Product Training 7/24/2018 SalesRep 7707 Copper Cave 17% Michael Carboni 4 Louis Stein San Antonio TX 78249 203 Power Systems Training 7/25/2018 SalesRep 1/3/2018 17% Michael Carboni 4 Louis Stein 7707 Copper Cave San Antonio TX 78249 6/9/2017 5 Christopher Demanby SalesRep 3/1/2017 100 Integrity Selling 4 Magnolia Drive 11% Michael Carboni Saratoga Springs NY 12866 3/1/2017 200 Hospital Infrastructure Introduction 9/17/2017 5 Christopher 5 Christopher 5 Christopher 5 Christopher 11% Michael Carboni Demanby SalesRep 4 Magnolia Drive 12866 Saratoga Springs NY 9/18/2017 Demanby 4 Magnolia Drive 3/1/2017 SalesRep Saratoga Springs 11% Michael Carboni 201 Hospital Infrastructure Advanced NY 12866 9/19/2017 3/1/2017 202 Sterilization Product Training Demanby SalesRep 4 Magnolia Drive Saratoga Springs 11% Michael Carboni NY 12866 203 Power Systems Training 9/20/2017 Saratoga Springs Seattle 3/1/2017 Demanby SalesRep 4 Magnolia Drive 11% Michael Carboni NY 12866 100 Integrity Selling 6/12/2014 3/3/2014 8% Michael Carboni 6 Marlyce SalesRep 2466 24th Ave E Bauer WA 98112 9/20/2014 SalesRep 3/3/2014 200 Hospital Infrastructure Introduction 6 Marlyce 6 Marlyce 2466 24th Ave E Seattle 98112 8% Michael Carboni Bauer WA 9/21/2014 SalesRep Seattle 3/3/2014 201 Hospital Infrastructure Advanced 2466 24th Ave E 8% Michael Carboni Bauer WA 98112 202 Sterilization Product Training 9/22/2014 6 Marlyce 2466 24th Ave E 3/3/2014 8% Michael Carboni SalesRep Seattle Bauer WA 98112 3/3/2014 9/23/2014 203 Power Systems Training 6 Marlyce SalesRep 2466 24th Ave E Seattle 8% Michael Carboni Bauer WA 98112 4/30/2016 8/8/2016 SalesRep 1/19/2016 100 Integrity Selling 200 Hospital Infrastructure Introduction Hall 47 Moody Avenue clovis 10% Jamie Zwolinski 7 Travis СА 93619 10% Jamie Zwolinski SalesRep 47 Moody Avenue 1/19/2016 1/19/2016 7 Travis Hall Clovis CA 93619 201 Hospital Infrastructure Advanced 202 Sterilization Product Training 8/9/2016 47 Moody Avenue Hall SalesRep Clovis 10% Jamie Zwolinski 7 Travis СА 93619 8/10/2016 1/19/2016 7 Travis Hall SalesRep SalesRep 47 Moody Avenue Clovis 10% Jamie Zwolinski СА 93619 8/11/2016 1/19/2016 203 Power Systems Training Hall 47 Moody Avenue clovis 10% Christopher Hudnut 7 Travis CA 93619 4/23/2011 257 Mallorca Way 1/31/2010 101 Coaching & Developing a Team 8 Jamie Zwolinski SalesManager San Francisco Bill Gates CA 94123 3/4/2013 100 Integrity Selling 6/15/2013 9 Christopher 9 Christopher 9 Christopher 29835 Buffalo Canyon Dr Hudnut SalesRep 77386 10% Jamie Zwolinski Spring TX 9/23/2013 9/24/2013 SalesRep 29835 Buffalo Canyon Dr 3/4/2013 200 Hospital Infrastructure Introduction Hudnut Spring 10% Jamie Zwolinski TX 77386 3/4/2013 29835 Buffalo Canyon Dr Hudnut SalesRep 10% Jamie Zwolinski 201 Hospital Infrastructure Advanced Spring TX 77386
202 Sterilization Product Training 8/10/2016 SalesRep 1/19/2016 Hall 47 Moody Avenue Clovis 93619 10% Jamie Zwolinski 7 Travis CA 203 Power Systems Training 8/11/2016 Clovis 1/19/2016 Hall SalesRep 47 Moody Avenue 257 Mallorca Way 93619 10% Christopher Hudnut 7 Travis CA 1/31/2010 3/4/2013 3/4/2013 Zwolinski 4/23/2011 101 Coaching & Developing a Team SalesManager Bill Gates 8 Jamie San Francisco CA 94123 6/15/2013 29835 Buffalo Canyon Dr 100 Integrity Selling 9 Christopher Hudnut SalesRep Spring 10% Jamie Zwolinski TX 77386 9/23/2013 9 Christopher 9 Christopher SalesRep 29835 Buffalo Canyon Dr 10% Jamie Zwolinski 200 Hospital Infrastructure Introduction Hudnut Spring TX 77386 201 Hospital Infrastructure Advanced 202 Sterilization Product Training 9/24/2013 9/25/2013 SalesRep 29835 Buffalo Canyon Dr 3/4/2013 Hudnut 77386 10% Jamie Zwolinski Spring TX 3/4/2013 29835 Buffalo Canyon Dr 9 Christopher Hudnut SalesRep Spring 10% Jamie Zwolinski TX 77386 203 Power Systems Training 9/26/2013 29835 Buffalo Canyon Dr 3/4/2013 9 Christopher Hudnut SalesRep Spring 77386 10% Jamie Zvwolinski TX 100 Integrity Selling 11/13/2016 8/1/2016 10 Magdalena Мaxwell SalesRep 384 North Road Chester 15% Jamie Zwolinski NJ 7930 2/21/2017 10 Magdalena Maxwell SalesRep 8/1/2016 200 Hospital Infrastructure Introduction 384 North Road Chester 15% Jamie Zwolinski NJ 7930 8/1/2016 2/22/2017 201 Hospital Infrastructure Advanced 10 Magdalena Мaxwell SalesRep 384 North Road Chester 15% Jamie Zwolinski NJ 7930 202 Sterilization Product Training 2/23/2017 8/1/2016 10 Magdalena SalesRep 384 North Road Chester 15% Jamie Zwolinski Маxwell NJ 7930 203 Power Systems Training 2/24/2017 SalesRep Chester 8/1/2016 10 Magdalena Maxwell 384 North Road 15% Jamie Zwolinski NJ 7930 4/2/2018 1/1/2018 101 Coaching & Developing a Team 11 Bill VP of Sales Portland Bill Gates Gates 123 Easy Street OR
ProductID Prod Desc UnitPrice InStockQTY SupplierID VendorPartlD SupplierName SupplierStreet SupplierCity SupplierStateSupplierZij ProductCost PurchasedQuantity GE INC 45066 25,000.00 $ 5.00 1000 Power Generator 50,000.00 3 PWR01 265 PIONEER BLVD SPRINGBORO OH 10 70584 S50,000.00 2000 Small Sterilizer 1 STO01 85,000.00 20.00 LA WHOLESALE INC. 301 HWY 167 N SUNSET LA 30 70584 70,000.00 $ 120,000.00 1 STO02 3000 Large Sterilizer 10.00 LA WHOLESALE INC. 301 HWY 167 N SUNSET LA 10 48375 $ 40,000.00 $ 4000 Hospital Bed 70,000.00 10.00 2 BD01 MEDLINE SUPPLY 43155 W 9 MILE RD DETROIT MI 20 5000 Security System $ 2.00 10,000.00
PartsRequired (QTY PartUnitPrice Part_StockQTY 2 5,000.00 1 8,000.00 ProductID ProductDesc PartID PartDesc 1000 Power Generato 1000 Power Generato 1000 Power Generato 110 Power Inverter 0 120 Diesel Engine 0 130 Generator Assembly Kit 1 4,000.00 0 1 3,000.00 4000 Hospital Bed 410 Bed Frame 0 8 $ 4000 Hospital Bed 420 Electric Motor 50.00 0 2 $ 4000 Hospital Bed 430 Control Panel 100.00 0 8 $ 4000 Hospital Bed 440 Wheel 5.00 0 1 2,000.00 5000 Security System 5000 Security System 5000 Security System 5000 Security System 510 Server 0 4 $ 520 Monitor – HD 300.00 0 20 $ 530 Camera Nightvision 4K 500.00 0 540 Camera Cable (in Feet) 500 $ 1.00 0
Expert Answer
Answer to Deliverable 1. Table Creation Using ERwin and Microsoft SQL Server, create the tables and populate them with data. The s…