CallAir case study - SQL queries, SQL reports, ERD

CallAir case study - SQL queries, SQL reports, ERD

Thursday, 10 March 2016 /

Consider the following requirements:

Your group is responsible for developing a database to support the fundamental data requirements of a customer call center for an established network service provider (includes landline, mobile and internet (broadband) services) - CallAir.  Due to increased competition in the market, CallAir.

Database Project (Database Normalization, ERD, Access Implementation and Basic Questions)

Database Project (Database Normalization, ERD, Access Implementation and Basic Questions)

Thursday, 25 February 2016 /

I- Short Answer Questions: Answer the questions briefly. 

1. Explain briefly referential integrity
2. Using a sentence each, based on your understanding of database design, list 2 advantages of using a database system in comparison with using traditional electronic file processing systems
3. Distinguish between the primary key, candidate key, and surrogate key
4. In the following relation, which tracks payments made out to payees,        Payment (Payment-Num, Payment-Amount, Payee-ID, Payee-Name, Payee-Address), the functional dependencies are:  Payment-Num - Payment-Amount, Payee-ID, Payee-Name, Payee-Address Payee-ID - Payee-Name, Payee-Address. Please explain why this relation is subject to insertion anomaly and deletion anomaly