Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Attempt all the problems.

Section-A

problem1) describe the rules for deriving relations which represent strong entity types, weak entity types, one-to-one binary relationship types, one-to-many relationship types, multi-valued attributes, and super class / subclass relationships.

problem2) describe the difference between hashing and indexing? What type of data structure might be implemented to support index-based search ensuring fast retrieval of information in a uniform fashion?

problem3) For each of the following application areas, describe why a relational database system will be inadequate. List all specific system components that would be need to modify.

i) Computer Aided Design

ii) Multimedia Database.

problem4) Consider following relations:

Faculty (F_id, F-name, F-designation) [The table contains several tuples having f-id as primary key]

Patient (P_id, P_name, p_address, date of admission) [The table contains several tuples and is stored on P_id]

Consultation date (C_date, F_id, P_id)

prepare the following queries:

(i) Find details of the whole faculty whose designation is a senior doctor and have got consultation date in July 2007.

(ii) Name the details of all patients who have got consultation dates fixed between 15th  August to Sept. 2007

Section-B

Case Study

Let us assume that XYZ University's Administration Office needs a database to handle student’s transcript data. The following are the requirements:

a) The database keeps track of each student's name, enrollment no. (E. No.), communication address and phone no., permanent address and phone no., date of birth, sex, class, department, college, major subjects (a 4-char code).

b) Some applications need to refer individually to the city, state (2-char abbrv.) and zip code (some use 5-digit, some use 9) of the student’s address. Some applications need to refer to student’s first and last names separately. Enrollment no. should be unique number for each student.

c) Each department has a name, a 3-char code, location (main building and room number), office phone, college, and a list of instructors. Many colleges are affiliated to the University. Department names and code are unique, within university.

d) Each instructor has his/her enrolment no., first name and last name.

e) The course catalog contains the list of courses that XYZ University offers. Each course has a number (e.g. 543), name, description, credit hours and department. Course numbers are unique within a department, but not unique across the university (so taken together, they are unique). Not every course is offered every semester.

f) Each section has a single instructor (first and last names - no team-taught class), semester (1-4) year (2-digit), course number and section number.

g) A grade report contains student's name, E. No, course number and section, letter grade (A, B,C, D, E).

Note: If the above user requirements leave out any significant detail, suppose that it is handled the way XYZ does things in the real world.

Answer the following problems based on the above requirements and specifications:

(i) Draw E-R diagram of the above. Name all the accompanying attributes/domains (including constraints).

(ii) Convert your E-R diagram to the relational schema:

• Use naming as specified in the E-R diagram.

• Use format as shown in the ex below, including:

• Table name in caps

• List of attributes with primary key underlined

• Foreign key specified with table/attribute it references (with .. cascade, it suitable)

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M93503

Have any Question? 


Related Questions in DBMS

Problem 1 please create a plsql procedure to print out the

Problem 1: Please create a PL/SQL procedure to print out the reservation ID, checkin date, and checkout date of reservations made by a guest. The input parameters is the name of the guest. There is no output parameter. P ...

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

Database management assignmentyou have been hired by

Database Management Assignment You have been hired by National Bank as their new database administrator. Your first task is to upgrade the bank's outdated computer system and implement a relational database management sy ...

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

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

Movie theater database entity-relationship modeldevelop a

Movie Theater Database: Entity-Relationship Model Develop a Microsoft Access database based upon the below Entity Relationship Model. Be sure to include tables, fields, keys, relationships, and data in your database. You ...

Suppose that you are the database developer for a local

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 upcoming training s ...

Task - overview of business casealive amp boating aampb is

Task - Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the avai ...

  • 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