IT540Assignment3 Solution - Organization Access Database with queries

IT540Assignment3 Solution - Organization Access Database with queries

Friday, 18 March 2016 /

Write SQL statements (queries) to answer the following questions (Make sure to replace XXX with your initials!):

1. Write an SQL statement to list all columns and all rows for the table Service. Save the query results as XXXQ1.

2. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master. Save the query results as XXXQ2

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