User Account

All Pages

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

  Database with data about a university

This assignment uses a database with data about a university; the database resides in our Oracle servers. The schema of the database is provided below. Keys are in bold face and underlined, field types are omitted; assume that appropriate foreign ..

  A prestigious university has recently implemented a

a prestigious university has recently implemented a consolidation strategy that will require it to centralize their

  Benefits and current trends of data warehousing

Explain the benefits and current trends of data warehousing and data mining and provide two (2) examples of quality companies successfully using a data warehouse to support your answer.

  What is the total i/o cost for sorting this file

How many sorted subfiles will there be after the initial pass of the sort, and how long will each subfile be?

  Write an anonymous block that places a substitution variable

Write an anonymous block that places a substitution variable (&) into a local variable of type varchar2. You will need to convert the types and round them to nearest tens unit

  Convert the erd into tables in access

Convert the ERD into tables in Access. Submit screenshots. Use Access tools to generate forms for users to populate the tables.

  A data distribution strategy for this retail store chain

Would you recommend a distributed database, a centralized database, or a set of decentralized databases for this retail store chain? Justify your answer.

  Planning & implementing a data warehouse project

ABC Industries is a diversified global organization that provides a variety of services, including financial and technical, and manufactures its own numerous products. Its manufacturing base is spread across the globe. ABC's production facilities ..

  Draw relational schema and show functional dependencies

Draw relational schema and show functional dependencies Comprehensive schema that shows existing PK and all functional, partial and transitive dependencies Detailed schema that shows existing PK and most functional, partial and transitive dependen..

  Normalize the following table into first normal form

Normalize the following table into first normal form. The table uses one row to record information about each student. A student may take one or more electives. This table is not in 1NF. Normalize this table so it is in 1NF. In your answer, list a..

  Design a database for an insurance company

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game.

  E-r diagrams are oriented reward which of the data models

Is it possible for two entities to be related to each other in two ways? For example, could entity A be related to entity B both 1:M and 1:1 at the same time?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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