Validation: Validation is done for comparing data with certain rules to find whether the data meets some criteria. It is a process for checking the data whether it make some meaning or not. Many programs perform validation at the time of entering the data or on entered data. Assume that, there is an admission of new student...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

I would like to get help to resolve the following case

Last Chance Securities The IT director opened the department staff meeting today by saying, "I've got some good news and some bad news. The good news is that management approved the payroll system project this morning. The new system will reduce clerical time and errors, improve morale in the payroll department, and avoid possible fines and penalties for noncompliance. The bad news is that the system must be installed by January 1st in order to meet new federal reporting rules, all expenses from now on must be approved in advance, the system should have a modular design if possible, and the vice president of finance would like to announce the new system in a year-end report if it is ready by mid-December." Tasks 1. Why is it important to define the project scope? How would you define the scope of the payroll project in this case? 2. Review each constraint and identify its characteristics: present versus future, internal versus exter- nal, and mandatory versus desirable. 3. What…

2. Signed Integers Unsigned binary numbers work for natural numbers, but many calculations use negative numbers as well. To deal with this, a number of different methods have been used to represent signed numbers, but we will focus on two's complement, as it is the standard solution for representing signed integers. 2.1 Two's complement • Most significant bit has a negative value, all others are positive. So, the value of an n-digit -2 two's complement number can be written as: Σ2 2¹ di 2n-1 dn • Otherwise exactly the same as unsigned integers. i=0 - • A neat trick for flipping the sign of a two's complement number: flip all the bits (0 becomes 1, or 1 becomes 0) and then add 1 to the least significant bit. • Addition is exactly the same as with an unsigned number. 2.2 Exercises For questions 1-3, answer each one for the case of a two's complement number and an unsigned number, indicating if it cannot be answered with a specific representation. 1. (15 pts) What is the largest integer…

Answer 2

Expert Solution & Answer

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Answer 8

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Answer 9

Chapter 11, Problem 7SG

Explanation of Solution

Validation:

Validation is done for comparing data with certain rules to find whether the data meets some criteria.

It is a process for checking the data whether it make some meaning or not.

Many programs perform validation at the time of entering the data or on entered data.

Assume that, there is an admission of new student...

Answer 10

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Answer 11

Explanation of Solution

Type of validity checks:

Alphabetic/Numeric Check:

Alphabetic check ensures the user enters only alphabetic values to the field. For example, in the field of First Name user should only enter the alphabetic character only.

Numeric checks ensure that user enters only numeric values to the field. For example, in the field of Current Enrollment, user can enter only integer values.

Range check:

Range check ensures that the user enters a value is within a specified range. For example, assume that the lowest per credit hour fee at the school is $75.00 and the highest is $370.75.

A range check ensures whether the credit hour fee field value is between $75.00 and $370.75.

Consistency check:

A consistency check will test the data in one field or two or more fields to ensure that the relationship is logically correct and their data format is correct.

In this check, it will concentrate to maintain the physical and logical consistency of database.

For example, the field date of admission of a student in particular institution cannot be earlier in time than the value in student’s date of birth field...

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 15

Ch. 11 - Define the terms, database and database software....Ch. 11 - Prob. 2SG Ch. 11 - Prob. 3SG Ch. 11 - Prob. 4SG Ch. 11 - Prob. 5SG Ch. 11 - Explain how a DBMS might manage deleted or...Ch. 11 - Prob. 7SG Ch. 11 - Prob. 8SG Ch. 11 - Prob. 9SG Ch. 11 - Prob. 10SG

Solution Summary: The author explains that validation is done for comparing data with certain rules to find whether the data meets some criteria.

Explanation of Solution

Explanation of Solution

Want to see the full answer?

Chapter 11 Solutions