Data integrity, Database Management System

You are required to implement integrity constraints within the database to enforce the following requirements: 
For Projects:

Start date must be supplied.
Start date cannot be in the past.
Finish date must be on or later than the start date.
Must have a supervisor value (supervised by cannot be null).
For Activities
Location must be supplied.
Finish time can be no later than 11.00pm.
Number of volunteers required must be greater than zero.
Date cannot be in the past.
Information requests

Create queries to answer the following information requests. Note: Do not use the Access query builder (QBE) to create your queries - you should type the queries in manually using SQL view.

1. List details (type, name) of all assets with a type of "Skill". Sort the list in alphabetical order of asset name.
2. List all details of projects that have been finished in the last ten days.
Hint: Use DateDiff function.
3. List the name and contact details of any members who have not yet volunteered for an activity. Note: It is not possible to answer this query with an inner join.
4. List the name of each member who may be able to contribute a trailer to a project.
5. How many members are able to provide cooking skills? Your result should be a single column with the heading ‘Number of Cooks'.
6. For each project, show the project name and the total number of volunteers required for all activities associated with that project.

Posted Date: 2/26/2013 4:17:14 AM | Location : United States







Related Discussions:- Data integrity, Assignment Help, Ask Question on Data integrity, Get Answer, Expert's Help, Data integrity Discussions

Write discussion on Data integrity
Your posts are moderated
Related Questions
Explain the concept of QBE? Query-by-example represents a visual/graphical approach for accessing information in a database by the use of query templates called as skeleton tab

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

(a) Data warehouse can be defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process. Explain ea

Q.   With the help of a suitable diagram gives module wise explanation of system architecture of DBMS. Sol. A Database management is a collection of interrelated data and col

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

What are called journaling file systems? File systems that support log disks are known as journaling file systems.

Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.


The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located