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
1. A company wants a report containing a breakdown of payroll by department. Input, which should be stored in 3 parallel arrays, includes each employee's department number, hourly

what are the reasons having variable length records

What are the responsibility of File manager? File Manager : Manager allocation of space on disk storage and the data structures used to represent within stored on disk. It is a

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

Write the C++ program having class name studentinfo, that is used to store the VU student information: This class should store your VUID, campus id, name and father name in the fol

Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

What is a Data Flow Diagram?  Data Flow Diagram: A data flow diagram is the graph that shows flow of data values from their sources in objects in the course of processes whic

Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

There are a number of possible solutions to the open ended brief. One of the simple ones is shown here without the PKs and FKs. It is important to think of how a number of tasks

basic structure of xml