Examine the database relations for bcnf violations

Assignment Help Database Management System
Reference no: EM131317581

NGO/CBO Database Project

The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix.

Database Specifications

In view of the questionnaire, and based on prudent consideration of the database specifications, the following high-level description of the database may be assumed:

  • The characteristics of an NGO entity include a unique ID, an native-language name, a Latin Name, an organization type, the year the NGO was founded, and the home country in which it exists. The home country of an NGO need not be the country in which it operates.
  • An NGO operates and has branches in its home country. It may operate and/or have branches in other countries. An NGO branch is identified with a unique ID. Each NGO has at least one branch, namely, its main office, whose head is the head of the NGO. Branch characteristics include the branch type, address, telephone and fax numbers, and the head of the branch.
  • NGOs engage in a number of activities that are categorized into larger activity classes. Each activity belongs to only a single class. NGOs may also have different scopes, i.e., operate in different geographical areas, as well as work with various population groups. NGOs may themselves be classified based on their activities, geographical coverage (or scope,) and beneficiary population groups. The characteristics of each scope and beneficiary group include a unique ID, name, and a succinct description.
  • NGOs carry out projects in their areas of activity aimed at their beneficiary groups in their locales. The characteristics of a project include a unique ID, title, starting date, and duration. Local, regional, and/or international donors of various types (individuals, organizations, charities, governments, etc.) provide funds for the projects. Funds encompass, but are not limited to cash, in-kind matching, technical assistance and training, and equipment, each of monetary value.
  • It is possible that certain projects of regional or global interest and/or scope are carried out by two or more collaborating NGOs of the same or different home countries.
  • Other NGO activities include, often as a component of some project, training, participation in workshops and conferences, and regular or intermittent publication of books, reports, newsletters, and/or advisories.

Assignment [I]:  

Consider the NGO/CBO questionnaire enclosed. It is suggested that you explore some of the NGO/CBO sites on the Web to verify the basic facts and collect additional information. Write down the additional information and/or requirements you gathered. Give the URLs for the sites contacted.

1- Draw an appropriate E/R diagram that satisfies the basic and additional facts, indicating, weak and subclass entity sets, whenever exist, multiplicity of relationships, and the key, or keys, for each entity set.  Distinguish between the parts of the E/R diagram pertaining to the given and extra basic facts.

2- Translate the E/R diagram to relational database schemas.

3- Specify a number of essential functional dependencies for each relation. Identify possible keys, whenever exist, and the primary key and foreign keys for each relation.

4- Examine the database relations for BCNF violations. Decompose the relations that are not in BCNF into collections of relations that are in BCNF as necessary.

[II]: Generate relational algebra [RA] expressions and expression trees to answer the following queries.  Use standard notation and appropriate RA terminology. You may need to modify the database schema to answer the questions below.

1- Identify all NGOs actively working in the Health, Education, and Gender group, together with the number of projects and total amount of funds received by each NGO.

2- Repeat the query in [1] for the Youth Development, Child Protection, and Nutrition group.

3- Identify the donors together with the total number of projects funded and amount of funds targeting the groups of activities in [1] and [2].

4- Repeat the queries in [1] and [2] to identify NGOs actively working in rural areas and slums together with the number of projects and total amount of funds received by each NGO.

5- Identify the donors together with the total number of projects funded and amount of funds targeting rural areas and slums.

[III] Create SQL code to answer the queries in [II].

Attachment:- Data Base Project Assignment.rar

Reference no: EM131317581

Defines the semantic checks necessary to produce

The third project involves writing the semantic analyzer for the compiler that was begun in the previous projects. To simplify the semantic error checking, you are to remove

Create an e-r diagram with maximum cardinalities

Create an E-R diagram with maximum cardinalities for the shipping of inventory to customers. Show this diagram as an REA model identifying resources, events, and agents.

Describe database backup

This paper will be 5 pages total: (a) Describe Database Backup. (b) Describe Disaster Planning. (c) Highlight the importance of the integration of both backups and disaster

Implement a good information systems plan

Implementation of business analytics, an organization will also need to implement a good information systems plan in order to collect, manage, and organize all of the data.

What is comp-xm

Comp-XM is familiar, yet different from your experience in Capstone or Foundation. You are the CEO. You will be making decisions on your own; you will not be a member of a t

Database and data warehousing design

This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assign

Create a database driven application for a business

Create a database driven application for a business. Identify a potential problem that this business might have. (ie, needs an automated inventory system, needs a payroll cal

Prepare a research topic on big data

Diagrams and tables must be numbered and labeled, and close to the first reference in the text - The paper should adhere to University writing standards pages in length, exclu

Reviews

len1317581

12/19/2016 1:59:05 AM

I need help with normalizations and BNCF and relational algebra I need only question 3 and 4 form assignment 1. And I need assignment 2. If you need some more files or anything else please let me know. I can provide you SQL tables and ERD to save much time. I need it as soon as possible. Submit a written report that includes: The complete E/R diagram and schema of the relational database fully specifying the given requirements and any other requirements gathered. Identify all keys, foreign keys, functional dependencies of the database relations. SQL code that creates the table’s structure, SQL code that loads the data, Data must be representative of fair size. RA expressions, RA expression trees, and SQL code that answer the given queries. Sample outputs for your SQL code.

Write a Review

 
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