Proposed entities in new database design

Assignment Help Basic Computer Science
Reference no: EM132911436

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.

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.

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

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

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

Reference no: EM132911436

Questions Cloud

What is the interest income for the year : On June 30, 2019, ABC acquired a non-interest bearing, 3-year, P6,000,000 face value serial bonds for P4,800,000. What is the interest income for the year
Six group of quality characteristics : Select a product with which you are familiar and list examples of its fatures for the six group of quality characteristics (quality dimensions).
Develop flexible strategic plans : Due to federally mandated changes why do hospitals need to develop flexible strategic plans, and what are some best practices.
How much account with the bank be : It is the first day of the year, How much your account with the bank be if you leave the money in the bank to be withdrawn all in 9 years from today?
Proposed entities in new database design : Discuss your rationale for the relationships between the proposed entities in this new database design.
What is the role of gatekeepers : 1. Consider a research study you might conduct. What is the role of gatekeepers? Give an example!
Determine the amount of interest to be capitalized : Determine the amount of interest to be capitalized? In order to receive full credit, your answer should include a calculation of actual interest
Prepare a schedule showing the net operating cash flows : Prepare a schedule showing the net operating cash flows in Years 1, 2, and 3. The Ewert Company is evaluating the proposed acquisition of a spectrometer.
Which is not one of objectives in utilizing standard costs : Which is not one of the objectives in utilizing standard costs? To allow management to readily determine and focus attention on special problem areas.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Detail about all the machine models we have discussed

Describe in detail about all the machine models we have discussed, including FA(Finite automata), DFA(Deterministic Finite Automata), NFA

  Ideas for setting up the wan service for the company

You are attending a meeting where your supervisor is presenting some ideas for setting up the WAN service for the company.

  Principle events of process and thread

Discuss the principle events of PROCESS AND THREAD used in both the hosting OS and the OS management of the appropriate QUEUES.

  Client brings a basket of items

Write a GUI application that acts as a cash register. In other words, a client brings a basket of items, their barcodes are scanned, and their total is calculated. The main window should have a menu bar with two menus Sale and Item.

  Define classes respectively for a book and a library

In the class, which describes the library, create methods to add a book to the library, to search for a book by a predefined author, to display information about a book and to delete a book from the library.

  Program that asks the user to enter two decimal numbers

Write a program that asks the user to enter two decimal numbers - The program should calculate and display the product and quotient of the two numbers. Use a function Product() to calculate the product.

  What might be difficulties of establishing such a profession

What might be the difficulties of establishing such a profession?

  Discussing the safe harbor provisions under hipaa

Describe the disaster recovery plan and who is responsible at your place of employment. Discussing the Safe Harbor provisions under HIPAA.

  Repetitive to reduce the amount

IT automation focuses on automating tasks that are repetitive to reduce the amount of time and/or resources needed to perform specific tasks.

  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.

  How much each country consume each good

Think of a 2 country world, say the US and the UK. Each country produces two goods, say food and cloth. Suppose 7 hours of labour are required to produce one unit of either good in the UK, whereas in the US it takes 2 hours to produce one unit food a..

  Critical incident protection

Critical Incident Protection. The importance of the document. How it pertains to your residency company.

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