Question1. Describe the problems which are associated with data redundancy.
Question2. Describe the 3 levels architecture of the Ansi-Sparc Model and demonstrate your answer with suitable diagram.
Question3. Define the following:
i) Domain Integrity
ii) Entity Integrity
iii) Referential Integrity
Question4. Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are main concern of the Cyber Transit product tracking information system. Dispatched items can be typified by item number (unique), weight, size, destination, and final date of delivery. Dispatched items are received in the Cyber Transit system at a single retail centre. Retail centres are typified by their type, unique ID and address. Dispatched items make their way to their destination via one or more Cyber Transit transportation medium (i.e. flights, truck deliveries). These transportation medium are characterized by a unique schedule number, a type (e.g. flight, truck) and a delivery route.
Create an Entity Relationship diagram that captures this information about Cyber Transit Ltd.