2. A database system uses an Apache web server, WebLogic Application server and an Oracle database....

Transcribed Image Text:

2. A database system uses an Apache web server, WebLogic Application server and an Oracle database. Draw a 3-tier architecture for this system. Use Internet to identify the latest versions of the above-mentioned software to use in your architecture diagram. 3. Aramex is a logistics, courier, and package delivery company. It relies on a company-wide information system. Shipped items are the heart of the Aramex product tracking information system. Shipped items are received into the Aramex system at a single retail center. Typically, shipped items can be characterized by a unique item number, dimensions, destination, weight, insurance amount, and final delivery date. Retail centers are represented by their type, ID, and address. The shipped items make their way to their destination via one or more standard Aramex transportation events, such as flights, etc. These transportation events are characterized by a unique schedule number, a type (flight, truck), and a delivery Route. i. Design an ER schema for this application and draw an ER diagram for that schema. Specify key attributes of each entity type and structural constraints on each relationship type. List any unspecified requirements, and make appropriate assumptions to make the specification complete. ii. Covert the ER model to a relational schema 2. A database system uses an Apache web server, WebLogic Application server and an Oracle database. Draw a 3-tier architecture for this system. Use Internet to identify the latest versions of the above-mentioned software to use in your architecture diagram. 3. Aramex is a logistics, courier, and package delivery company. It relies on a company-wide information system. Shipped items are the heart of the Aramex product tracking information system. Shipped items are received into the Aramex system at a single retail center. Typically, shipped items can be characterized by a unique item number, dimensions, destination, weight, insurance amount, and final delivery date. Retail centers are represented by their type, ID, and address. The shipped items make their way to their destination via one or more standard Aramex transportation events, such as flights, etc. These transportation events are characterized by a unique schedule number, a type (flight, truck), and a delivery Route. i. Design an ER schema for this application and draw an ER diagram for that schema. Specify key attributes of each entity type and structural constraints on each relationship type. List any unspecified requirements, and make appropriate assumptions to make the specification complete. ii. Covert the ER model to a relational schema