List the different attributes for each entity

Assignment Help Basic Computer Science
Reference no: EM13984606

As a database expert, you were approached by a nonprofit organization to convert their data into a digital format. Currently all what they have are the paper forms shown below. The nonprofit organization collects money from donors either directly or through events. The collected money will be used to sponsor projects to help families in need. In the first project assignment (first phase) you will use the paper forms to identify the entities, their attributes, functional dependencies, and candidate keys. There will be NO coding, and you will NOT using Access for this assignment.

Use the forms to:

Identify the four entities the organization needs to track.

List the different attributes for each entity

Identify and document the functional dependences for all four entities (for example: EvenID (can determine) è (event description, .......)

Identify the Determinant for each entity, which can be used as Primary key. Some entities might not have a unique determinant, in this case create the proper surrogate key that can determine other attributes in an entity

Reference no: EM13984606

Questions Cloud

Favorite flavor of ice cream : In a recent survey, 35 percent indicated chocolate was their favorite flavor of ice cream. Suppose we select a sample of ten people and ask them to name their favorite flavor of ice cream.
Gas prices fluctuate often and in both directions : How responsive do you think consumers will be to the price change when these fluctuations occur due to changes in supply? Why? Use the various determinants of elasticity to explain your answer. How does the price elasticity of demand for gasoline imp..
What is the probability four or more name chocolate : a. How many of those in the sample would you expect to name chocolate? b. What is the probability exactly four of those in the sample name chocolate? c. What is the probability four or more name chocolate?
Suppose there is an increase in the saving rate : Suppose there is an increase in the saving rate. This increase in the saving rate will cause an increase in which of the following once the economy reaches its new steady state equilibrium?
List the different attributes for each entity : Identify the Determinant for each entity, which can be used as Primary key. Some entities might not have a unique determinant, in this case create the proper surrogate key that can determine other attributes in an entity
Positive population growth and technological progress : Assume that an economy experiences both positive population growth and technological progress. A reduction in the saving rate will cause:
Middle childhood or adolescent population : Create a brochure for prevention and treatment of that issue targeted at the middle childhood or adolescent population.
Prepare a contribution margin income statement for last year : What are some of the non-financial aspects of the automation decision that PB management should consider when deciding whether to embark on the automation project or not?
Explanation of the fmla law and appraise : Provide a brief explanation of the FMLA law and appraise this law.Which of these individuals is eligible for Family & Medical Leave Act (FMLA) leave?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Disaster recovery plan

This assignment consists of two (2) sections: a Disaster Recovery Plan (DRP), and a written DRP analysis. You must submit both sections as separate files for the completion of this assignment. Additionally, you may create and /or assume all necess..

  Recognize the features of the internet that you require to

identify the features of the internet that you need to use in your mobile or home office including the followingwhich

  We are interrupted or disintegrated

Research is compelling that it takes us approximately 4 to minutes return to our work with the same level of through processes whenever we are interrupted or disintegrated. Is it possible to information is fairly constant?

  The data rate of the transmission line is doubled

Bernie's speed is doubled; (ii) each tape capacity is doubled; (iii) the data rate of the transmission line is doubled.

  Rewrite the insertion algorithm

Rewrite the insertion algorithm to use this observation. Do this by having findPos maintain, with an additional variable, the location of the ?rst inactive cell it encounters.

  Electronic health care record

As a chief security officer (CSO) for a large hospital, you are charged with securing medical health care records. More recently, senior hospital administrators are seeking to provide a complete online portal for all its doctors and patients

  Forms and data validation

Forms and Data Validation

  What are the key questions an it auditor

What are the key questions an IT auditor can ask to help determine which end-user applications have top priority in an organization?

  Disaster recovery and business continuity policies

Disaster Recovery and Business Continuity Policies

  How cisco it provides remote access for small offices

Case Study 2: Cisco's Remote Access Go to Cisco's Website and read, "How Cisco IT Provides Remote Access for Small Offices and Teleworkers", located at http://bit.ly/MkvlbA. According to the study, an IDC forecast from December 2007

  Introduction the area of cyber security

Introduction The area of Cyber security is rapidly evolving, with important research being conducted at all levels. The current and potential damage to societies, businesses, and individuals is a topic of growing importance to Governments across t..

  How would you find the approximate value ofm

You are told nothing else aboutf, but you may ask for the value off(x) for any values ofx you choose. How would you find the approximate value ofm? How accurately could you findmif you could choose only 10 values ofx for which to evaluatef(x)?

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