Data integrity, Database Management System

Assignment Help:

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.


Related Discussions:- Data integrity

Differance between procedural and non procedural dml, Differance between pr...

Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural

Explain natural join, Explain natural join? Natural Join - Similar as...

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

What is a sub-query, (a) What is a Sub-Query? (b) What is the differen...

(a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh

What is structured query langauge, What is Structured Query Langauge (SQL)?...

What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was formed by IBM research for the databases that adhere to the relational model. It havi

Illustration of implementation of inheritance, Illustration of implementati...

Illustration of implementation of inheritance Let us take the illustration of implementation of inheritance. Suppose that we are about to implement the Stack class and by now w

Describe entity referential integrity and integrity, Describe entity refere...

Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

Differentiate between primary and secondary storage, Differentiate between ...

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Explain what is relation, Explain What is Relation? A database relatio...

Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

Define radix conversion method, Define Radix conversion method  One cle...

Define Radix conversion method  One clever way to transform binary numbers to BCD notation (binary-coded decimal) is the "double dabble algorithm". It can be adapted to transfo

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd