{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Module_5_Exercises_-_Open_Office

Module_5_Exercises_-_Open_Office - Module 5 Exercises...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
115.107 Management Information Systems Module 5 Exercises - Open Office Page 1 Module 5 Exercises 1 Topic Query relational databases using Query by Example and SQL query languages. Create database reports in OpenOffice Base. 2 Relevance to Assignments These exercises will prepare you for completing Part 3 of the Assignment. 3 Exercises Queries are used to describe which data is to be retrieved from the database. Queries are used to realize business requirements for retrieving data needed in transaction processing or decision support. Database reports format and style data obtained via queries for presentation purposes. The exercises to follow use the RealEstate.mdb database you downloaded with this document. The ER model and the relational model for this database are given below. You will find that ER diagrams are quite useful when you need to join data of several entity types. House Offer Client Agency 1 0..* 1 0..* 1 0..* 0..* 1..* makes for via listed with
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon