Purchase Solution

Database System Design and Implementation

Not what you're looking for?

Ask Custom Question

Defining data relationships is an important process during the database design. I need some help answering these questions:
1. Describe your idea for a database that includes at least four tables.
2. Explain the relationships between the tables.
3. How did you go about identifying the tables and the relationships? What process did you use?
4. Why do you think relationships are important in database design?
5. What are the benefits of defining relationships in your database design?
6. What are some issues of having a database that is not normalized?
7. Why would you consider creating a database that is not normalized?

Purchase this Solution
Solution Summary

The solutions explains database design reasons, and why a normalized database is not always needed, per questions in assignment. Reference included.

Solution Preview

Solution:
1./2. For a company that has sales districts, a database would be needed that does several things. Within the database there would need to be information about the districts, including identification of the district, the cities within the district, and any breakdowns of the cities. There would also need to be a table to identify companies that currently or potentially use the products we sell. Another table must identify the salespersons and the districts they work and their specific company representation. For example, a salesperson in district 4, working Orlando, Florida works with companies A,B, and C. While another salesperson in district 4 may work in Southern metro areas of Orlando and the Tampa area and have companies D,E, and F. This prevents mistaken encroachment by either into another's territories. Finally a table of products is a must.

3. Deciding on the most ...

Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Motivation

This tests some key elements of major motivation theories.

Basics of corporate finance

These questions will test you on your knowledge of finance.

View More Free Quizzes
Related BrainMass Solutions

  • Why do databases need redesigning?

    Database Processing - Fundamentals, Design, and Implementation by David M.

  • Predicting Data Volumes and Number of Users

    of users as well as the data volumes allows the project of design, implementation, maintenance, and repair of the database easier on the entire IT team.

  • Software Development Life Cycle

    * Physical Design focuses on implementation of the entities and relationships of the logical database model using a relational DBMS. c) Implementation: The DBA is providing database access interfaces and programs.

  • Project Management Life Cycle

    Project Implementation phase * Software coding and testing On the base of the software detailed design developing and documenting each unit, database and test. Conducting and documenting unit testing.

  • MICROSOFT ACCESS EXPERT

    Implementation: This was the physical realization of the database and application design. This is the deliverable we are presenting in the final. Phil Switzer will perform the actual implementation at his office.

  • Normalized Relational Database Management System

    Assignment Design a completely Normalized Relational Database Management System that meets both the high-level and technical requirements of the web-based project management system. I.

  • Database Life Cycle

    A systematic approach has always been the basis of a quality and reliable database application product or computer system where defects are identified from the onset and addressed as design, development, and testing phases occur.

  • Tasks assigned to each phase of SDLC

    A project contains Analysis, Definition, Design, Implementation, Maintenance, and Support phases. Tasks assigned to each phase are determined.

  • Justification of good database design

    269479 Why is the design of a database so important? Explain some of the problems that can arise later in the system development lifecycle, if great care and planning does not go into the design of the database.

  • Computer Theory and Web Databases

    This response discusses the concepts of a web database, netiquette, system design compared to system analysis, and slugging.

View More Related Solutions