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

Stored procedures and stored functions - major assessment

Stored Procedures and Stored Functions - Major Assessment Task Background You are to create tables to store product and customer data. You will create a number of stored procedures and functions (SPFs) to insert / update ...

Assignmentoverviewthis assignment gets you started thinking

Assignment Overview This assignment gets you started thinking like a database designer. You will learn concepts from chapters 1 through 5 and and implement them using MS Access. You should complete the following activiti ...

Part aexercise 1 data scienceread the article at

Part A Exercise 1: Data Science Read the article at http://datascience.berkeley.edu/about/what-is-data-science/ and answer the following: What is Data Science? According to IBM estimation, what is the percent of the data ...

Databaseplease read carefully and if u sure u can do it

Database Please read carefully, and if u sure u can do it email me., please Design a database (entity and relationship tables in Access) for a small college department library. You should have the entities and relationsh ...

Database individual assignmentdesign a database entity and

Database: Individual Assignment Design a database (entity and relationship tables in Access) for a small college department library. You should have the entities and relationships you need to support: Purchase books Sell ...

Application creating and populating a databasesuppose you

Application: Creating and Populating a Database Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. ...

Database design and implementationtask 1 - database

Database Design and Implementation Task 1 - Database Design Your first task is to design a database for the scenario detailed on the following pages. Your final database design should comprise of approximately 10 entitie ...

Your assignment should be submitted in a single word doc

Your assignment should be submitted in a single Word doc (.doc or .docx). It should include your scenario diagram for Problem 1, and your Ruby source code for Problems 2 and 3. Contact me or post to our discussion board ...

Database design and development assignmentintroduction -

Database Design and Development Assignment Introduction - The sample solution of assignment 1 will be released on the course website approximately two (2) weeks after the assignment 1 due date.  You must use that sample ...

Database design continueduse the attached database to

Database Design Continued Use the attached database to complete the following assignment: You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report. 1) Create ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate