answer q 1 & 2

Below are tables that you will use to answer some of the questions on this assignment. Study them carefully before answering the questions. It is a database used by the shipping department of a food manufacturing company to ship material lots against customer orders. Customers place customer orders (C_ORDER) that have order details. The shipping department fills those orders by transferring material lots (TRANSFER) from the warehouse to shipping vehicles for shipment (SHIPMENT), recording the customer order and line item for which the transfer is being made, along with the lot number and quantity that is transferred. Some data types for certain attributes are shown after the tables. CUSTOMER : Table CUSTOMER ICI C_NAME C STREET C CITY 1000 Lehigh University 210 Packer Street Bethlehem 1050 New Jersey Institute of Technology 500 Martin Luther King Bild Newark 1200 New York University 10 Folly Square New York - 3950 Columbia University 4677 Broadway New York 873 University of Massachusetts 125 Springfield Avenue Amherst C.ZIP C STATE PA NU NY NY MA 18015 07077 10033 10027 85656 C_ORDER : Table ORDER NO CUST PO NUMBER CUSTOMER D ORDER STATUS ORDER DATE 3565 06-050 1000 Shipped 9/7/2006 3567 4999 1200 Shipped 9/6/2006 3600 58910 3950 Shipped 10/1/2006 3601 06-102 1000 Open 10/1/2006 3602 58913 3950 Open 10/1/2006 ORDER BALANCE C_ORDER DETAIL : Table ORDER NO ORDER LINE MATERIAL D ORDER QTY ORDER PROMISED DEL DATE 3565 1 430 6 11/1/2005 3565 2 350 30 11/1/2006 3555 3 235 11/1/2006 3567 1 430 10 11/2/2006 . 2 905 30 112/2006 3600 1 243 10 12/6/2006 3601 1 243 15 12/20/2006 3602 1 243 12 12/22/2006 588 88 OOOOOO 3567 . 15 12 ses IMILIE TRANSFER : Table S TRANSACTION NOILOT NUMBER ORDER NO TRANSFER OTY 984 962 3565 2 970 3565 4 367 910 3565 30 901 3565 10 930 970 3567 10 991 966 3567 30 1000 10105 3600 10 TRANSFER DATE 10/30/2006 1030/2006 11/12/2006 112/2006 11/5/2006 11/5/2006 11/5/2006 ORDER LINE ITEM SHIPPING NO 1 6019 1 6018 2 6020 3 6020 1 6022 2 8022 1 6125 1 SHIPMENT : Table SHIPPING NO SHIPPING VEHICLE NO 6010 200 6020 200 6022 190 6125 200 DATE SHIPPED 10/60/2006 11/2/2006 11/5/2005 12/5/2006 MOTY ON HAND 30 . MATERIAL_LOT : Table LOT NUMBER MATERIAL D M DATE_CREATED M_QUANTITY_CREATED 901 235 2/10/2006 40 910 350 3/20/2006 30 940 333 3/4/2005 50 944 333 3/8/2006 48 950 360 3/15/2006 50 955 905 3/10/2006 30 962 430 40/2005 970 430 5/5/2006 90 380 7/2/2005 992 380 7/4/2006 10105 243 4/1/2006 10109 243 4/2/2006 32 50 49 50 + . 1 DB9SDORRONS 88888888 + 26 20 40 32 MATERIAL : Table MATERIAL D MATL DESCRIPT +236 Chile w Beans +243 Mac & Cheese in Tray + 330 Chicken Noodle Soup + 360 Beef Ravioli in Sauce + 380 Fish Chowder + 430 Turkey Soup + 905 Beef Stew UNIT OF MEASURE Cases Cases Cases Cases Cases Cases Cases Attribute_Name S TRANSACTION NO LOT NUMBER ORDER NO Description Data Type Unique ID for movement of a material lot out Nurn integer) of the warehouse for shipment Unique identifier of a material lot Nun integer) Identifier of the order for which the transfer is Numinteger) being made Identifier of the line item the transfer Numinteger) intended to satisfy in whole or in part The number of units transferred Nurni decimal) Date on which the transfer is made Date/Time Unique identifier of a shipment to a customer Numinteger ORDER LINE ITEM TRANSFER QTY TRANSFER DATE SHIPPING NO Attribute_Name SHIPPING NO Data Type Nun integer) Description Unique identifier of a shipment to a customer Vehicle on which shipment is made Dute on which shipment is made SHIPPING VEHICLE NO DATE SHIPPED Nun integet Date Time 1. (2.5 points) Draw an IDEFIX model from the tables shown above. Using the data as shown above to guide you, follow the syntax of the IDEFIX methodology closely, indicating primary and foreign keys, cardinalities, mandatory and optional relationships, etc., etc. 2. (1 point) The food company sends an XML file to cach customer when a customer order is finally completely shipped. It is given the class name ORDER_SHIPMENT. It contains as a header element the attribute ORDER_NO. Sub elements include LINE_ITEM. SHIPPING NUMBER, DATE_SHIPPED, LOT_NUMBER, QUANTITY_SHIPPED (Transfer_Qty). Assume that an ORDER_SHIPMENT Schema has already been created by an industry consortium using the www.w3.org standard. Create a document of the ORDER_SHIPMENT class for ORDER_NO 3567. 3. (1.5 points) Write the HTML code for the following Web page. (Hint: the URL for the MIE department is http://www.qu.edu.ca/engineering/academics/mie Homework 2 localhost/w2.html Information System Design Many companies nowadays invest quite a lot on Information Technology (IT). These investments have had a significant impact on the efficiency of resource use within companies. the relationship between companies and their suppliers and customers, and the business strategies adopted by companies that use IT as a competitive tool. For all these reasons. It has become an important subject in the academic training of engineers and industrial managers. Link: Department of Mechanical and Industrial Engineering What is your user name? What is your password? Page Designed by: Write your name and email here VERCOA VONCORD VE PURCHASE ORDER PO NUMER VENDOR_D090