Essay 6BUS1070 – QBE-Extracting Information – Case Study – Data Analytics Assignment Help

Assignment Task

The details of case study –

CW1

A. Create an ERD (Entity-Relationship Diagram)

B. Create an Attribute-PK-FK listing
C. Prepare sample data

CW2

A. Build an MS Access Database from the approved ERD

B. Add the approved data to your Database
C. Query your database using QBE and SQL

Agenda

• ASG2b

Show the spreadsheet you
prepared for this week with
some data records for each entity
ready for inspection this week

• ASG2b

Where to concentrate your efforts

to create lots of data records
for selected entities

• ASG2c

Introduction to creating

QBE queries using MS Access
Query By Example (GUI)