Ask DBMS Expert


Home >> DBMS

Metropolitan City Church Management

Metropolitan City Church Management (MCCM) has hired you as a consultant to modernize the file processing system that stores information about churches, priests, church members, and attendance at church events.

The data that are currently stored in the file processing system are:

Church_Name                                     Name of a church

Church_Address                                 Address of a church

Church_Phone                                     Church's phone number

Priest_Name                                        Name of a priest

Priest_Birthdate                                  Priest's birthday

Title                                                     Priest's title (rank)

Family_Number                                  A unique identifier for a family

Family_Name                                      Last name of a family that is a member of a church

First_Name_Head_of_Household      First name of a head-of-household

First_Name_Significant_Other           First name of the significant other of a head-of-household

First_Name_Child                               First name of a child

Birthdate_Child                                  Birthdate of a child

Event_Date                                         Date an event occurs

Event_Name                                       Name of an event

Total_Attendance                               Number of people attending an event

Family_Attendnace                             Number of people from one family attending an event

You are given the subsequent facts about the situation:

  • A church can have many priests assigned to it.
  • A priest may be assigned to more than one church.
  • A family belongs to only one church.
  • A family has only one head-of-household; a head-of-household may have a significant other (spouse or other life partner). Of course, there may be more one than child in a family.
  • An event is something that takes place on a specific date.
  • A person can attend many events and (hopefully) an event is attended by many people.
  • The church wants to know which families attended which events and how many people from each family were there. For example, the database should store data indicating that four members of the Smith family attended the Crafts Fair.

1. Draw an ER diagram for your database scenario.

The ER diagram should use only three relationships

1)one to one relationship

2)one to many  relationship

3)many to many relationship

please go through visual paradigm for making ER diagram using those relationships itself

2. Design a set of 3NF tables for your database scenario.

3. Consider the following query.

"Show me a list of the last names of all the families who attended the Holiday Bizzare on December 12, 2000."

  • Using the relations you created for the church database, write a SQL query that will answer the query above.
  • Using the relations you created for the church database, write the relational algebra that will answer the query above.

4. (Consider the following query:

            "Show me the name and birthdate of all priests not assigned to a church."

  • Using the relations you created for the church database, write a SQL query that will answer the query above.
  • Using the relations you created for the church database, write the relational algebra that will answer the query above.

5. Uncontrolled concurrent use of a database can lead to serious problems. What are these problems? Why do they occur?

6. Assume that you have been asked to look at the database design being used by an organization. When you see the tables, you realize that they are all in first normal form; none are higher. Explain to the organization's management the three types of problems you would expect to find in these relations.

7. Discuss four major threats to database security. For each threat you identify, state at least one solution to that threat.

8. Discuss the characteristics of an organization for which a data warehouse would be suitable. Aside from huge amounts of money, what resources does an organization need to support a data warehouse or data mart? For what purposes is a database warehouse best used?

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9134969
  • Price:- $35

Priced at Now at $35, Verified Solution

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As