Error checking or referential integrity programming

Assignment Help Basic Computer Science
Reference no: EM133058722

Put yourself in the position of the data analyst who is working with both the information technology department and the research team to develop the research data warehouse that will further this important research in the organization discussed in the article. You have been given permission to move forward utilizing resources within the information technology group to begin the process of database design. The information technology project manager has asked you to reflect on the overall design of the database and provide her a list of the type of entities that should be reflected in the new database as well as the nature of the relationships between these entities (one-to-one, one-to-many, or many-to-many).

Put together a memo to outline these entities and relationships so that the information technology department can secure the appropriate data administrator in programming resources to begin the technical design of the database.

1. Explain the data entities that you see being necessary to design the new research database inclusive of data from the electronic health record, genetic sources and research administration sources.

2. Describe the relationship between these entities in terms of one-to-one, one-to-many, or many-to-many database relationships.

3. Discuss your rationale for the relationships between the proposed entities in this new database design.

4. Describe any error checking or referential integrity programming that you would like included in the overall design of the research database.

Reference no: EM133058722

Questions Cloud

Dissertation is the methodology : An important component of your dissertation is the methodology chosen. Discuss the topic that you are selecting for your dissertation.
Networking-key to successful teamwork : Consider the different teams presented in your reading assignment. How do the teams manage their team boundaries?
Describe importance of data in analytics : How do you describe the importance of data in analytics? Can we think about analytics without data? Explain.
Difference between field and record in relational database : Discuss the difference between a field and a record in a relational database. Articulate the purpose of data tables in relational database design.
Error checking or referential integrity programming : Describe any error checking or referential integrity programming that you would like included in the overall design of the research database.
Ensure there is data visualization in homework : Ensure there is data visualization in the homework and note how it relates to the three principles selected.
Overview of their scoring system : Do a bit of research on CWE, Common Weakness Enumeration. Write a brief overview of their scoring system.
Industry experts believe blockchain is technology : Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years.
Recall information system : Recall an information system that you have used regularly, such an online banking system, a payroll system,

Reviews

Write a Review

Basic Computer Science Questions & Answers

  How the hash functions change as the records are inserted

Assume that blocks are split whenever an overflow occurs, and show the value of n at each stage.

  Construction of a data warehouse

Analyze some dependencies between data mining and the construction of a data warehouse.

  What is marketing discipline

What is marketing discipline? What is most people's perception of marketing discipline?

  Biola center for christian thought conference on humility

Earn extra credit worth two assignments by attending the Biola Center for Christian Thought Conference on Humility: Moral, Religious, Intellectual.

  Consumer-to-business and business-to-business transactions

Identify two types of e-commerce and describe how they have changed consumer-to-business and business-to-business transactions.

  Do you get the quadratic b-spline scaling function

Apply the cascade algorithm to the dilation equation for the quadratic B-spline scaling function. Do you get the quadratic B-spline scaling function?

  What are baseline security requirements

What are baseline security requirements that should be applied to the design and implementation of applications, databases, systems, network infrastructure,

  Write a program that asks a user for a file name and prints

Write a program that asks a user for a file name and prints the number of characters, words, and lines in that file.

  Find the maximum weight allowed by the airline

The average weight of an airline passenger's suitcase is 45 pounds (. The standard deviation is 2 pounds (s = 2). If 20% of the suitcases are overweight

  Action research methodology model

Complete a research project based upon the Action Research Methodology Model that is learned in the course.

  Implementation of virtual private network

Describe the issues involved with deployment, placement, and implementation of a Virtual Private Network (VPN).

  Find the angle of depression

Air Travel At a local airport, a light that produces a powerful white-green beam is placed on the top of a 45-foot tower. If the tower is at one end of the runway, find the angle of depression needed so that the light extends to the end of the 220..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd