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

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

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

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

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

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

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Discussionnormalization and redundancy please respond to

Discussion "Normalization and Redundancy" Please respond to the following: • Suggest one of the problems that normalization seeks to solve within a database. Describe one example of your suggested problem, and explain th ...

Lab modifying a database design in visiothis assignment

Lab: Modifying a Database Design in Visio This assignment contains two Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use "Appendix A: De ...

Analytical assignment individual or group of max two

Analytical Assignment (Individual or Group of Max two students) What is Research article? Review articles provides summary of current state of the research on a particular topic. Ideally, the writer searches for everythi ...

  • 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