Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1:

Design the ER diagram for an XYZ Information Technology Training Institute which would meet information requirements for their training programmes. Clearly indicate entities, relationships, cardinality and the key constraints. The explanation of the environment is as follows:

Institute has 15 instructors and could handle upto 100 trainees for each training session. Institute offers 5 advanced technology courses, each of which is taught by the team of 2 or more instructors. Each instructor is allotted to the maximum of two teaching teams or might be assigned to do research each trainee undertakes one Advanced technology course per training session.

problem 2: 

Staff No.    Branch No.    Branch Address                    Name     Position      Hrs/Week
E101           B02             Sun Plaza, Delhi, 110001     Rahul       Assistant     16
E101           B04             2/3 UT, Delhi, 110111         Rahul       Assistant     9
E122           B02             Sun Plaza, Delhi, 110001     Medha     Assistant     14
E122           B04             2/3 UT, Delhi, 110111         Medha     Assistant     10

Do the Normalization for above given table.

problem 3:  

Describe how “GROUP By” clause works. What is the difference between the WHERE and HAVING clauses? Describe them with the help of ex for each.

problem 4:   

Given the relational schema:
ENROL (S#, C#, Class) - S# represents student number
TEACH (Prof, C#, Class) - C# represents course number
ADVISE (Prof, S#) - Prof is project guide of S#
PRE_REQ (C#, Pre_C#) - Pre_C# is prerequisite course
GRADES (S#, C#, Grade, Year)
STUDENT (S#, Sname) - Sname is student name

Give queries expressed in relational algebra, tuple calculus and domain calculus for the following:

(i)   List all students taking courses with Prof Ashok.

(ii)  List all student names who have chosen Prof Rahul as project Guide.

(iii) List those professors who teach more than one class.

(iv) List all student names who got Grade A in the year 2012 in C# P202.

(v)  List all students who have taken the pre-requisite course Pre_C# P304.

Note: Make appropriate assumptions, if any.

problem 5: 

What are the advantages of indexed-sequential file organisation? With the help of the ex describe the structure of indexed-sequential file.

problem 6:   

prepare the differences between Hierarchical, Network and Relational data models with the help of appropriate exs. Describe why relational data model is a better choice over the two. Justify the answer.

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

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

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

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

Projectfalcor supplies is a distributor of high tech

Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main compe ...

Assignmentthis assignment consists of two sections a design

Assignment This assignment consists of two 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 nam ...

Virtualization fundamentalsunit 3 research projectwrite an

Virtualization Fundamentals Unit 3 Research Project Write an overview of *any two* of the following topics. Each overview should be between one half and one full page long. You should use a minimum of two sources for eac ...

Project database and programming designthis assignment

Project: Database and Programming Design This assignment consists of two 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 a ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

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

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

  • 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