Advanced Databases Assignment

Advanced Databases Assignment - Student Edition Lab...

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

View Full Document Right Arrow Icon
Student Edition Lab Assignment: Advanced Databases CASE: You are an administrative assistant for a local real estate developer. The sales agents often need to access information about the towns and schools, as well as details about homes that are listed, sold, rented, or taken off the market. If this data were in a database, it could be easily accessed and analyzed, yielding helpful information for the agents. You have been charged with the task of designing a database for the office. Your supervisor spent the weekend going through the office files to identify the data she wants to include in the database. She created the following list for you to use: Agent information: Client information House/Prope rty information House /Property information (continued) City/Town information State information Name Name Owner Property ID Name Name Agent ID Address Address Sales commission ZIP State code Monthly stipend Phone City House type (P=Cape, C=Colonial, R=Ranch, S=Split-level, M=Contemporary ) State
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Advanced Databases Assignment - Student Edition Lab...

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

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