Question

In: Computer Science

Database systems and Information systems An information system performs three sets of services: It provides for...

Database systems and Information systems

An information system performs three sets of services:

  • It provides for data collection, storage, and retrieval.
  • It facilitates the transformation of data into information.
  • It provides the tools and conditions to manage both data and information.

Basically, a database is a fact (data) repository that serves an information system. If the database is designed poorly, one can hardly expect that the data/information transformation will be successful, nor is it reasonable to expect efficient and capable management of data and information.

The transformation of data into information is accomplished through application programs. It is impossible to produce good information from poor data; and, no matter how sophisticated the application programs are, it is impossible to use good application programs to overcome the effects of bad database design. In short: Good database design is the foundation of a successful information system.

Database design must yield a database that:

  • Does not fall prey to uncontrolled data duplication, thus preventing data anomalies and the attendant lack of data integrity.
  • Is efficient in its provision of data access.
  • Serves the needs of the information system.

The last point deserves emphasis: even the best-designed database lacks value if it fails to meet information system objectives. In short, good database designers must pay close attention to the information system requirements.

Systems design and database design are usually tightly intertwined and are often performed in parallel. Therefore, database and systems designers must cooperate and coordinate to yield the best possible information system.  

The SDLC traces the history (life cycle) of an information system. The DBLC traces the history (life cycle) of a database system. Since we know that the database serves the information system, it is not surprising that the two life cycles conform to the same basic phases.

There are two basic approaches to database design: top‑down and bottom‑up.

Top‑down design begins by identifying the different entity types and the definition of each entity's attributes. In other words, top‑down design:

  • starts by defining the required data sets and then
  • defines the data elements for each of those data sets.

Bottom‑up design:

  • first defines the required attributes and then
  • groups the attributes to form entities.

Although the two methodologies tend to be complementary, database designers who deal with small databases with relatively few entities, attributes, and transactions tend to emphasize the bottom‑up approach. Database designers who deal with large, complex databases usually find that a primarily top‑down design approach is more appropriate.

Even if a generally top‑down approach is selected, the normalization process that revises existing table structures is (inevitably) a bottom‑up technique. E-R models constitute a top-down process even if the selection of attributes and entities may be described as bottom-up. Since both the E-R model and normalization techniques form the basis for most designs, the top‑down vs. bottom-up debate may be based on a distinction without a difference.  

Assignment

Write two to three paragraphs answering each of the following questions:

  • What are business rules? Why are they important to a database designer?
  • What is the data dictionary's function in database design?
  • What factors are important in a DBMS software selection?

Solutions

Expert Solution

What are business rules? Why are they important to a database designer?

Business Rules are used every day to define entities, attributes, relationships and constraints. Usually though they are used for the organization that stores or uses data to be an explanation of a policy, procedure, or principle.

  The data can be considered significant only after business rules are defined, without them it’s just records, but to a business they are the characteristics that are defined and seen by the company.

  Business Rules help employees focus on and implement the actions within the organizations environment. Some things to think about when creating business rules are to keep them simple, easy to understand, keep them broad so that everyone can have a similar interpretation.

What is the data dictionary's function in database design?

A good data dictionary provides a precise description of the characteristics of all the entities and attributes found with in the database.

The data dictionary makes it easier to check for the existence of synonyms to verify appropriate relationships.

The data dictionary contents are developed and used during six DBLC phases like DataBase Initial Study,DataBase design,Testing and evaluation etc.

What factors are important in a DBMS software selection?

The DBMS manages the interaction between your applications and underlying database.When choosing a DBMS software you should consider some points before making a decision they are

1.Data Model:

To decide on which model works best for you, you should ask yourself: Do you have a data structure which you can easily reflect in a relational model or do you need to work with unstructured data? How do you retrieve and work with the data?

2.Data Consistency:

  Nowadays, collecting data is not a big effort any more. But, keeping the data consistent becomes even more important as more sources feed into the database. Therefore, consistency rules are very important and the ability to define these should be considered when choosing a new DBMS.

3.Data Security:

  Data availability is a key business success factor and should be guaranteed at all times. The ability to backup and restore the databases is essential and needs to be possible with your chosen DBMS.

There are also some other important factors to choose a Database software are DataProtection,Efficiency,Usability etc


Related Solutions

A country's financial system provides three services to savers and borrowers. One of these services is...
A country's financial system provides three services to savers and borrowers. One of these services is a. the ability of savers to maximize risk. b. the ability of the financial system to buy and sell stocks. c. the ability of savers and borrowers to maintain a sound investment. d. the ability of the financial system to transfer information.
Although database systems have become the system of choice for new and reengineered systems, are there...
Although database systems have become the system of choice for new and reengineered systems, are there any situations where a traditional file based system might be chosen instead? Explain your answer with examples.
Marketing Information Systems. identify at least three sources of input to a marketing information system for...
Marketing Information Systems. identify at least three sources of input to a marketing information system for a product or service offering. Identify at least three types of information for Tesla Model S or X should use in a comprehensive marketing information system for decision making purposes. Why did you chose each of them?  
Powerjob Inc. provides employment consulting services. The company adjusts its accounts monthly but performs closing entries...
Powerjob Inc. provides employment consulting services. The company adjusts its accounts monthly but performs closing entries annually on December 31. The firms’s unadjusted trial balance dated December 31, 2019 is shown below. Other data: 1.       Accrued but unrecorded and uncollected consulting fees earned at December 31 total : $25000. 2.       The company determined that $15000 of previously unearned consulting fees had been earned at December 31. 3.       Office supplies on hand at December 31 total $300 4.       The company purchased all of its equipment...
Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in...
Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in Toronto, Canada. The firm, which bills $172 per hour for services performed, is in a very tight local labor market and is having difficulty finding quality help for its overworked professional staff. The cost per hour for professional staff time is $82. Selected information follows. Billable hours to clients for the year totaled 9,200, consisting of information systems services, 5,520; e-commerce consulting, 3,680. Administrative...
Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in...
Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in Toronto, Canada. The firm, which bills $164 per hour for services performed, is in a very tight local labor market and is having difficulty finding quality help for its overworked professional staff. The cost per hour for professional staff time is $74. Selected information follows. Billable hours to clients for the year totaled 8,400, consisting of information systems services, 5,040; e-commerce consulting, 3,360. Administrative...
Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in...
Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in Toronto, Canada. The firm, which bills $164 per hour for services performed, is in a very tight local labor market and is having difficulty finding quality help for its overworked professional staff. The cost per hour for professional staff time is $74. Selected information follows. Billable hours to clients for the year totaled 8,400, consisting of information systems services, 5,040; e-commerce consulting, 3,360. Administrative...
Shearwater Council owns and operates an animal shelter that performs three services: housing and finding homes...
Shearwater Council owns and operates an animal shelter that performs three services: housing and finding homes for stray and unwanted animals, providing health care and neutering services for the animals, and pet training services. One facility is dedicated to housing animals waiting to be adopted. A second facility houses veterinarian services. A third facility houses the director, his staff, and several dog trainers. This facility also has several large meeting rooms that are frequently used for classes given by the...
What is important aspect about REA modeling for Accounting Information Systems database design?
What is important aspect about REA modeling for Accounting Information Systems database design?
Describe the importance of databases and database management systems in managing organizational data and information. Include...
Describe the importance of databases and database management systems in managing organizational data and information. Include in your discussion the types and some examples of database management systems. Also, address the advantages and disadvantages of using a DBMS.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT