Question: Apply the following validations before inserting the record into the database. 1 . EmpNo: must contain only digits and the maximum number of digits is

Apply the following validations before inserting the record into the database.
1. EmpNo: must contain only digits and the maximum number of digits is 7
2. Name : must contain only alphabets and at least 3 alphabtes
3. Salary : must contain only digits and the maximum number of digits is 4
4. Address: may contain alphabets and digits.
5. Dept No : the values of this field may only be 10 or 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

You work for "The World's Greatest Bank and you have been asked to design and program a web page using PHP/MySQL. Your program should support a bank client database. Your database should maintain...

Q:

You work for "The World's Greatest Bank" and you have been asked to design and program a web page using PHP/MySQL. Your program should support a bank client database. Your database should maintain...

Q:

You work for The Worlds Greatest Bank and you have been asked to design and program a web page using PHP/MySQL. Your program should support a bank client database. Your database should maintain...

Q:

CSE Programming & Algorithms for Engineers Spring 2018 Programming Assignment 5: Putting it all together 1 Setting up the Programming Environment 1. Create a new directory (folder) called hw5 and...

Q:

Design a web application for "Muscat Road Runners with the following specifications (Use Bootstrap in all the pages. This project aims at maintaining all the information pertaining to the site's...

Q:

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

i need creat login page ues Microsoft Expression Web4 in need login form.php and login code.php this language for php Design a web application for a Visitor Management System with the following...

Q:

PART A: a. Create the database and table in MYSQL, PhpMyAdmin as shown below in the screenshot: Database Name: Product_YourID Table Name: Prod Field / Column Name Datatype with size Constraint...

Q:

In C++ language please Implementing Indexing Using B-Trees An index is a file that facilitates insert, delete, and search operations on a database. The efficiency of these operations depends on the...

Q:

Rachel, a female, is 52, weighs 110 pounds, and is in good health. She wants to be a firefighter with the Middlebury Fire Department. In response to an ad in the local newspaper, Rachel submitted an...

Q:

Evaluate the limit: limxa limx0 x-a (x a)-a (a + x) - X -1-a -1

Q:

Sequoia Partners provides two types of client consulting services: environmental consulting and legal consulting. Consider the following two independent scenarios for Sequoias activity usage and cost...

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

Discuss the purpose of an application letter. Describe the two kinds of application letters. (Objective 1)

Q:

Analyze the professional organizations in your field of study. List those organizations in which you believe membership would strengthen your job candidacy. Find out whether they offer a student...

Q:

Technology. Teamwork. Form a group of two or three students and review the listings in the classified ads of a local or regional newspaper. Assess the employment opportunities in relation to your...