Ask Question, Ask an Expert


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

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

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

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

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Question - databasesuse database software such as microsoft

Question - Databases Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.) A. Create a new database. Add tables based on the design of ...

1 how are qbe tools and sql similar2 how are they

1. How are QBE tools and SQL similar? 2. How are they different? 3. What is a data warehouse? 4. How does it differ from a database?

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

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Lab manualin this lab you will learn how to use ddl and

Lab Manual In this lab you will learn how to use DDL and Oracle Enterprise server to create user accounts, modify, monitor and delete them. You will take the first look at object permissions in Oracle. The last assignmen ...

Listed the five important software components of a dbms the

Listed the five important software components of a DBMS: the DBMS engine, the data definition, data manipulation, application generation, and data administration subsystems. Which of those are most and least important to ...

  • 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