Add a validation rule for date of birth

Assignment Help Database Management System
Reference no: EM131003763

1. Add a Validation Rule for Date of Birth so no one under the age of 18 can be added to the table. Hint: subtract the DOB from today's date and divide by 365.25 (watch the parentheses and pay attention to the arithmetic "order of operations" ) Do NOT use any functions here or in the queries that we did not discuss. (More below on using "today's date" function)

2. Make a Validation Rule to ensure that the Check Out Date is later than the Check In Date.

3. Make a select query with a calculated field for age, to list only guests between 20 and 40 years of age! Make sure to enter a range of ages in your table so you have something to display.

4. Make a Parameter query that allows the user to choose which birth month to display. So when the user is prompted for a birth month, they might type in 3, for March, and only the records which have a Date of Birth in March, will display.

5. Make an Update Query that will add the phrase "Free Champagne for this Preferred Guest" to the Comments field, but only if the guest stays for 8 days or more.

Attachment:- midt.rar

Verified Expert

Solution .rar file it consists of two files one is word file which has 6 questions and answers with screen shot and other one is database created in ms access. I solved all questions in ms access 2013. Here i checked validation rule, executed update and select query.

Reference no: EM131003763

Questions Cloud

Prepare the appropriate journal entry to record income taxes : Taxable income is $180 million. No temporary differences existed at the beginning of the year, and the tax rate is 40%. Prepare the appropriate journal entry to record income taxes.
A system initially has an internal energy e : A system initially has an internal energy E of 501 J. It undergoes a process during which it releases 111 J of heat energy to the surroundings, and does work of 222 J. What is the final energy of the system, in J?
Characteristic of the industrial model of work : Which statement is not characteristic of the industrial model of work? Which words have never been used to describe work
Calculate dhrxn for the reaction : Calculate ΔHrxn for the following reaction: CH4(g)+4Cl2(g)→CCl4(g)+4HCl(g) Use the following reactions and given ΔH′s.
Add a validation rule for date of birth : Make an Update Query that will add the phrase "Free Champagne for this Preferred Guest" to the Comments field, but only if the guest stays for 8 days or more.
Suppose the unearned portion of the rent collected : Refer to the situation described in BE 16-4. Suppose the unearned portion of the rent collected was $40 million at the end of 2012. Taxable income is $200 million. Prepare the appropriate journal entry to record income taxes.
Which of the following moral rights could be waived : Which of the following moral rights could be waived in order to get a job or an increase in employment benefits
Calculate the normal derivative of given function : Suppose that f(x, y) = x2y4 is defined over a domain Ω = {{x, y)|x2 + y2 ≤ 1} (a circle of radius one in the xy-plane). Calculate the normal derivative of f(x, y) at P. Calculate the tangential derivative of f(x, y) at P.
Find the total charge of the line charge q : A line of charge lies along the x-axis extending from x=0m to x=3m. The line charge densit is a function of the distance from the coordinate beginning x and is given by λ=2x [nC/m]. Find the total charge of the line charge Q.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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