Purchase Solution

Two Primary Steps to Database Design

Not what you're looking for?

Ask Custom Question

We explored the two primary steps to database design - conceptual design and physical design. We discussed the importance of having representatives from all key stakeholders in the conceptual design to ensure the accuracy of the design. We analyzed who should facilitate the conceptual design and create the ER diagram.

Next we discussed the physical design step, who is involved and what the outcome is.

As we wrap-up the week, who decides which employees will have access to data in a particular database? Why should the organization be careful when deciding who as read only access vs. read and update access to data?

Purchase this Solution

Solution Summary

This solution discusses the two primary steps to database design.

Solution Preview

When a database is open to all employees within an organization, changes, amendments, and alterations that can not be reversed can be completed in addition to security issues.

Depending upon the department (marketing, finance, sales, IT, etc.) there should be limitations on who can access the database. Due to government regulations or other policies that required adhering, these limitations can be read ...

Purchase this Solution


Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.