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

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

This assignment consists of two 2 sections a design

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name accor ...

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Some people used to believe that data warehouses would

Some people used to believe that data warehouses would quickly replace databases for both online transaction processing (OLTP) and online analytical processing (OLAP). Of course, they were wrong. Why can data warehouses ...

Projectinstructionsfor the purpose of grading the project

Project Instructions: For the purpose of grading the project you are required to perform the following tasks: Instructions 1 Open the start file Day Spa that you recently downloaded then Save the workbook as Lastname_Fir ...

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

Assignment database modeling and normalizationimagine that

Assignment: Database Modeling and Normalization Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solution ...

Normalizationsuppose that you are the database developer

Normalization Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcom ...

  • 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