INFO1003_Foundamental of IT_2012 Semester 2_tutorial week 10

University of Sydney_INFO1003_Foundamental of IT_2012 Semester 2

1.

What are the two main types of databases? What are the difference between the two?

2. Map the previous Domain real estate ERD (found in the Data Modelling Exercise) into tables.

Part A: Mapping to Tables

Map the previous SMH ERD (found in the Data Modelling Exercise) into tables

Part B: Creating the Database

Follow the procedure on page 128 of the reference book to create an SMH database in Microsoft Access. The details of the SMH database was outlined in Exercise 2 of the Data Modelling exercise. After you created all the constraints necessary for the database, start populating the tables with at least 5 rows.

Map the previous Sydney Uni ERD (found in the Data Modelling Exercise) into tables

Part A: Creating Forms

Follow the instructions from page 135 of the reference book in order to create a form for easy entering of data into the database. The database can be downloaded .

University of Sydney_INFO1003_Foundamental of IT_2012 Semester 2

Part B: Creating Reports

Continuing with the Chipmunk database, follow the instructions from page 143 of the reference book in order to create a summary report of all the data in the Chipmunk database.

3. Download the provided database and generate the two Forms and one Report. You may need to download the Android image .

One of the forms needs to at least demonstrate the use of Tabs. The Tab Control is available under the Design tab >> Controls

group.

University of Sydney_INFO1003_Foundamental of IT_2012 Semester 2

Database Exercises

INFO1003| FOUNDATIONS OF INFORMATION TECHNOLOGY

University of Sydney_INFO1003_Foundamental of IT_2012 Semester 2

Database Exercises

INFO1003| FOUNDATIONS OF INFORMATION TECHNOLOGY

University of Sydney_INFO1003_Foundamental of IT_2012 Semester 2

Database Exercises

INFO1003| FOUNDATIONS OF INFORMATION TECHNOLOGY