subject
Engineering, 13.11.2019 00:31 martymangaroo

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. 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 (where f is your first initial). reminder: to obtain your sql database file, right-click on your database and select the detach menu option. detaching your database will produce two output files, a .mdf and a .ldf file. 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 customerid (pk) customername customerstreet customercity customerstate customerzip creditlimit salesrepid (fk) of employee_t order_t orderid (pk) customerid (fk) of customer_t customerponumber orderdate duedate shipdate order_line_t orderid composite (pk), (fk) of order_t productid composite (pk), (fk) of product_t orderquantity product_t productid (pk) productdescription unitprice stockquantity fabricated_t productid composite (pk), (fk) of product_t. productid partid composite(pk), (fk) of product_t. productid partquantity quantity of partid that goes into productid (example, 2 tires in one bicycle) product_supplier_t producid composite (pk), (fk) of product_t supplierid composite (pk), (fk) of supplier_t vendorpartid this is the id the vendor (i. e., supplier) uses in their system), similar to customerponumber in the order_t. productcost purchasedquantity supplier_t supplierid (pk) suppliername supplierstreet suppliercity supplierstate supplierzip employee_t employeeid (pk) employeename employeestreet employeecity employeestate employeezip managerid (fk) unary employee_course_t employeeid combination (pk), (fk) of employee_t courseid combination (pk), (fk) of course_t completiondate course_t courseid (pk) coursedescription sales_commission_rate_t employeeid (pk), (fk) of employee_t commissionrate (hint: only employees with commission rates should be added to this table).

ansver
Answers: 2

Another question on Engineering

question
Engineering, 04.07.2019 18:10
Refrigerant 134a enters an insulated compressor operating at steady state as saturated vapor at -26°c with a volumetric flow rate of 0.18 m3/s. refrigerant exits at 9 bar, 70°c. changes in kinetic and potential energy from inlet to exit can be ignored. determine the volumetric flow rate at the exit, in m3/s, and the compressor power, in kw.
Answers: 1
question
Engineering, 04.07.2019 18:10
Water at the rate of 1 kg/s is forced through a tube with a 2.5 cm inner diameter. the inlet water temperature is 15°c, and the outlet water temperature is 50°c. the tube wall temperature is 14°c higher than the local water temperature all along the length of the tube. what is the length of the tube?
Answers: 3
question
Engineering, 04.07.2019 18:20
Aheavily insulated piston-cylinder device contains 0.02 m3 of steam at 300 kpa and 200 °c. 1.2 mpa. d this process. team is now compressed in a reversible manner to a pressure of etermine the entropy change and the work done on the steam during this process
Answers: 1
question
Engineering, 04.07.2019 19:10
Asteel wire of 2 mm diameter is fixed between two points located 2 m apart. the tensile force in the wire is 250n, if its density of steel is given by 7830 kg/m3 the fundamental frequency of vibration hz? ?
Answers: 3
You know the right answer?
Using erwin and microsoft sql server, create the tables and populate them with data. the source of y...
Questions
question
Physics, 14.09.2020 15:01
question
English, 14.09.2020 15:01
question
History, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
History, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Biology, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
question
Mathematics, 14.09.2020 15:01
Questions on the website: 13722360