Dbms, computer programming, Programming Languages

2. Design an ER diagram for an IT training group database that will meet the information need’training programme. Clearly indicate the entities, relationships and the key constraints. The description of the environment is as follows:
The company has 12 instructors and can handle up to 100 trainees for each training session. The company offers 5 Advanced technology courses, each of which is taught by a team of 2 or more instructors Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research Each trainee undertakes one Advanced technology course per training session.
3. An organization has multiple retail stores. These stores have to keep track of products, suppliers, customers and employees. They also make discount offers on several items during festivals. Make an ER_diagram stating assumptions used, if any. Use concept of keys, aggregation, generalization, cardinality etc. in a proper way.
Perform the following queries in SQL based on your ER-diagram:
? Find the details of products which have got more than discount.
? Find the details of stores which have maximum sales monthly.
? Find details of employee who have been working with retail stores more than 15 years.
Posted Date: 3/21/2012 1:27:12 AM | Location : United States







Related Discussions:- Dbms, computer programming, Assignment Help, Ask Question on Dbms, computer programming, Get Answer, Expert's Help, Dbms, computer programming Discussions

Write discussion on Dbms, computer programming
Your posts are moderated
Related Questions
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

depth estimation from block matching algorithm motion estimation

PLEASE HELP ME ORACLE PROGRAMING TRIGGER

This assignment will make use of arrays and functions to simulate a game. ASSIGNMENT DESCRIPTION This program will simulate part of the game of Yahtzee! The player will

Tasks: Write a Perl script assignGrades.pl to assign letter grades to the students. Please use the classList2.txt file. Upon invoking, the script will access the file classL

Task .Task 1 Database design This task will allow you to demonstrate the following Learning Outcomes (LOs): LO 2. Justify the design and development of the application and critica

Programming Project Specification: IRC or Internet Relay Chat is an application that lets multiple users communicate via text messages with each other in common "virtual" rooms.

Vacation Envy - Travel and Photo Sharing Website Site Overview- Vacation Envy is a travel as well as photo-sharing site. Make your travel map, share photos and show off al

Define Functions with no arguments and no return values? When a function has no arguments it doesn't receive any data from the calling function. Likewise, it doesn't return any

what is the difference between class and interface