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

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

The discussion questionbased on your research and readings

The discussion question Based on your research and readings for the week, respond to the following discussion topics. • Often, systems have only one level of security when it comes to databases. Imagine that someone is t ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

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

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

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

Problem iyoull be happy to know that we made a strong case

Problem I "You'll be happy to know that we made a strong case to manage¬ment that we should hire a new systems analyst to specialize in ecommerce development," says Al Falfa, a systems analyst for the multi-outlet intern ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Database designfrom textbook fundamentals of database

Database Design From Textbook: Fundamentals of Database Management Systems 2nd Edition. 1. Convert the Video Centers of Europe, Ltd., entity-relationship diagram in Exercise 2.2 into a well structured relational database ...

1 analyse situations andor environments for the application

1) Analyse situations and/or environments for the application of database solutions including web connectivity 2) Create, alter and remove relational tables, indexes and data using an appropriate database language. 3) Ex ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen