Reference no: EM131468702
Question: Think back to Module 01 when we discussed the importance of planning a database. Just like building a home, it is important to have a plan and blueprint documented before even laying the foundation. Databases require the same approach. You will need to plan and build a blueprint or Enterprise Relationship Diagram to determine the structure of the database.
Before you even begin creating a diagram, you first need to know what you're trying to accomplish with the database. Some database-planning tasks involve interviewing or surveying users, evaluating business processes, and developing use cases. User surveys can be performed to determine how the database will be used and what type of data will be stored in it. Some sample questions are:
How many records do you need to be stored?
What information do you plan to store?
Will you need to add or update information? How often?
How many users would need to access the database?
What kinds of reports will you need?
Evaluating business processes may involve creating a process flow map to document business activities from beginning to end. All processes that interact with the database should be considered and you should document what information these processes need.
A use case is a description of how the database should function based on any inputs or queries. Adding or updating records would be an example of a use case.
Once the planning tasks have been completed, you're ready to begin creating your blueprint, the entity relationship diagram or ERD. This is a logical representation of the database or also called a model. Just like an architectural blueprint for a home, the ERD will serve as your model for the database. The ERD does not store data, and you can't retrieve data from it. It is simply a model.
Microsoft Visio is a popular tool used to create ERD diagrams. Below is a sample ERD for the AdventureWorks sample database.
Find the two one-period forward rates
: Bond B has a 10% coupon and sells for $1,055.12. Find the two one-period forward rates that must hold for these bonds.
|
Distribution channel for business marketing tangible product
: What are the major differences between a distribution channel for business marketing tangible products
|
Use the multiplicative seasonal method to develop forecast
: Use the multiplicative seasonal method to develop the forecast for each quarter.
|
How does servant leadership differ from path-goal theory
: Liz is a team leader at a local grocery store Recently her boss said that she needs to address the negative attitudes of employees.
|
What information do you plan to store
: Think back to Module 01 when we discussed the importance of planning a database. Just like building a home, it is important to have a plan and blueprint.
|
Recent practical example of an australian organisation
: Describe, using academic references, the international challenges and possible opportunities for managers operating in a global environment.
|
What is the average running time complexity of algorithm
: Consider two sets of integers, S = {s1, s2, ..., sm} and T = {t1, t2, ..., tn}, m = n. Propose an algorithm (only pseudo-code) that uses a hash table of size m.
|
How many parameters did we use for line detection
: M1522.001000 Computer Vision (2017 Spring) Homework. How many parameters did we use for line / circle detection
|
Unique challenges associated with team work in health care
: What are some of the unique challenges associated with team work in health care? How do you see teamwork fitting in with accountable care organization mandates
|