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
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

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.

C# variables and classes

This quiz contains questions about C# classes and variables.

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.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.