Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Benevolent Oratory, Reading and Independent Notions Group:


The Benevolent Oratory, Reading and Independent Notions Group (BORING) has hired you as a consultant to modernize the file processing system that stores information about their poetry reading programs.

The data that are stored in their current data files are:

DATA ITEM         CONTENTS

R_NUMB             A unique number arbitrarily assigned to each reader
R_NAME             Name of a person who has given or will give a poetry reading
R_ADDRESS        Home address of an poetry reader
R_PHONE           Telephone number of an poetry reader
WORK               Title of a poem that has been, may be, or will be read
POET                Author of a poem that has been, may be, or will be read
ISBN                 Book International Standard Book Number (unique throughout world; different editions of same title have differentISBNs)
BOOK_TITLE       Title of a book in BORING’s library
AUT_ED             Author or editor of a book in BORING’s library
EDITION            Edition of a book in BORING’s library
PUBLISHER         Publisher of a book in BORING’s library
YEAR                 Year of publication of a book in BORING’s library
PAGE                 Page on which a poem begins in a book in BORING’s library
PROG_NUMB        A unique number arbitrarily assigned to each program
PROG_TITLE        Title of a specific program at which poems have been or will be read
READING_DATE    Date when a specific occurence of a program will or has taken place
PLACE                Name of a location where a program can, has, or will be held
CITY                  City where a specific location for a program is found
CAPACITY           Seating capacity of a particular location

Important note: One of the restrictions that have been placed on your works is that no further data items can be added. You may not create any arbitrary unique keys that are not already present! Use concatenated keys are needed.

You are given the following facts about the way in which BORING’s poetry reading programs are operated:

1) A program is a group of people getting together at one place on one date to read a selection of poems. It is identified by a program number.

2) Each person who reads poems can be at only one program in a given day.

3) Each person who reads poems can be at many programs during the year.

4) Each program of poetry readings is given at one specific location and on one specific date. (Note: this does not mean that the titles of programs are unique.  For ex, there may be an annual reading of Frost’s poems with the same title each year. The poems read each year, however, may be different.)

5) Each person who reads poems can read many poems during a single program, but each poem is read only by one person.

6) While each poem is read only once during a given program, it may be read at many programs during the year.

7) A program consists of the reading of many poems.

8) Each poem is read by a specific person, as part of a specific program, at a specific location, on specific date.

9) The titles of poems are not unique, though any given poet has written only one poem with a given name.

10) Each place at which programs are given holds only one program on any day, although the same program might be given on the same day at another location, using different readers and with different poems.

11) The names of places at which programs are held are not necessarily unique, but any given city will only have one location with a given name.

12) The BORING library holds many books, each of which contains many poems. Not every poem that appears in a book in the library has been read or is scheduled to be read.

13) A poem does not need to appear in a book in the BORING library to be read at a program. For ex, readers sometimes read poems that they have written themselves.

14) A poem can appear in many books and, of course, a book contains many poems.

problem 1: Draw an ER diagram for your database scenario.

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

problem 3: Consider the following query.

“Show me a list of poets and poem names along with the names and phone numbers of the people who are going to read them on 12/29/00 at the Elks Hall in Metropolis, NY.”

a) Using the relations you created for the BORING database, prepare the sequence of relational algebra operations needed to answer the query above.

b) Using the relations you created for the BORING database, prepare a SQL query that will answer the query above.

problem 4: Consider the following query:

“Show me a list of the poem names and poets of all poems in the BORING library that have never been read or are not scheduled to be read.”

a) Using the relations you created for the BORING database, prepare the sequence of relational algebra operations needed to answer the query above.

b) Using the relations you created for the BORING database, prepare a SQL query that will answer the query above.

Answer two, and two only, of the following problems. You may use exs to support your discussion, but those exs must not duplicate those presented in the lessons or in your text books.

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

problem 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. describe to the organization’s management the three types of problems you would expect to find in these relations.

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

problem 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.:- M94859

Have any Question? 


Related Questions in DBMS

Assignment business rules for sam symthes

Assignment: Business Rules for Sam Symthe's Database Overview Sam Smyth is an expert puppy trainer. His specialty is training troubled puppies to behave for their owners. The name of his business is Sam Smythe's Kennel f ...

Unlimited pickers is a group of workers who have joined

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to l ...

Moving average forecasting modelsmoving average forecasting

Moving Average Forecasting Models Moving average forecasting models are powerful tools that help managers in making educated forecasting decisions. A moving average is mainly used to forecast short historical range data. ...

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Ngocbo database projectthe purpose of this project is to

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 ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal stra ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Capstone project purpose of the assessmentthe purpose of

Capstone Project Purpose of the assessment: The purpose of this assignment is to identify new learning, self realisation and plan for improvement. Students will have an opportunity to explore the use of the online tools ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro