Design a database for a world-wide package delivery company (e.g., DHL or FedEX). The database must be able to keep track J of customers (who ship items) and customers (who receive items); some customers(may do both. Each package muust he identifiable and trackable, so the database must be able to store the location of the package and its history of locations, Locations include trucks, planes, airports, and warehouses Cles giua. Your design should include:(Compound, Derived, Multi-valued attributes weak entity, specialization or generalization) Two designs required : 1) ER or UML Model. 2) Relational Model (Mathematical)

Design a database for a world-wide package delivery company (e.g., DHL or FedEX). The database must be able to keep track J of customers (who ship items) and customers (who receive items); some customers(may do both. Each package muust he identifiable and trackable, so the database must be able to store the location of the package and its history of locations, Locations include trucks, planes, airports, and warehouses Cles giua. Your design should include:(Compound, Derived, Multi-valued attributes weak entity, specialization or generalization) Two designs required : 1) ER or UML Model. 2) Relational Model (Mathematical)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The form of data independence in which the schema may be modified conceptually without affecting the exterior structure is referred as as
Goals for the design of the logical schema include
The conditions under which the database designer should employ supertype and subtype connections are outlined.
Advanced Database 1- Convert this relational database to a key value database Subject Comp Stnum Name Avg Eyear 9611 احمد رضوی 17 1396 9712 16 1397 Elec پوریا محمدی 9813 رضا احمدی IT 18 1398 9811 زینب اکبری IT 17 1398 9914 Elec رویا کیمیای ی 16 1399 9815 dabli Comp 19 1398 پورمحمدی 2- Convert this relational database to a document database 3- Design a column family database for school. In school there are teachers and students. Teachers present courses for students. 4- Design Graph database for railway in Iraq. The railway connects different railway stations.
Within the context of a typical database environment, there must to be at least nine unique components mentioned.
The most important component of the architecture is the MetaData component. This is because it is the most critical component of the data warehouse design.
This category includes features of database designs such as program separation, support for numerous users, and the application of catalogs.
Search at least two (2) frameworks can you use to effectively mine different data sets.
Identifying relationships, non-identifying relationships, and non-specific relationships should all be described in a database's representations of their respective types.
How does data binding impact the development of user interfaces in a multi-platform environment, such as web, mobile, and desktop?
One subset of data models is those that store concepts in the same hierarchical structure as the underlying database.