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 DocumentRight Arrow Icon
115.107 Management Information Systems Module 5 Exercises - Open Office Page 2 Table Columns Primary Key Comments ClientTbl name, phoneNumber, id id HouseTbl address, id id AgencyTbl name, phoneNumber name listedWithTbl houseId, agencyName houseId, agencyName houseId is a foreign key into HouseTbl, while agencyName is a foreign key into AgencyTbl OfferTbl date, id, amount, clientId, houseId, agencyName id clientId is a foreign key into ClientTbl, houseId is a foreign key into HouseTbl, and agencyName is a foreign key into AgencyTbl. 3.1 Formulating query by example query involving single table Query By Example (QBE) is a graphical approach to formulating queries. It is very easy to formulate QBE queries involving a single table. Overview Using QBE, create a query that would return names of all clients at the following phone number: 234-4352.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

Module_5_Exercises_-_Open_Office - Module 5 Exercises...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online