Diagram Tool The data modeling tool ER Assistant will be used to create an

Diagram tool the data modeling tool er assistant will

This preview shows page 1 - 2 out of 2 pages.

and which customer areas need more intense marketing to increase sales and customer population. Diagram Tool: The data modeling tool ER Assistant will be used to create an entity-relationship diagram (ERD) of the proposed Upscale customer tracking database. The purpose of the ERD will be to create a graphical representation of the customer tracking database and illustrate the logical structure of the database. The
Image of page 1
ERD will clearly show the entities such as people, objects or concepts, for which Upscale wants to store and track information about. Each entities properties or characteristic called attributes will clearly be identified through the ERD diagram. In addition, the ERD diagram will show how the entities act upon each other or are associated with each, which is known as relationships and their cardinality. Database: The Upscale customer tracking database will be created through Oracle 11g which is an object-relational database management system. The Oracle 11g database will be accessed using Virtual Desktop Applications (VDA) Hardware and Software: ER Assistant: data modeling software for creating, editing, and printing an ERD Oracle SQL Developer: user-friendly interface for connecting to the database and for running the queries and SQL scripts. VMware Horizon client: software used to act as the broker between the clients desktop and the VDA where the Upscale database will be located.
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '09
  • Yelena - TA
  • Database management system, customer tracking database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture