Question: Write test data for the following fields in a database (the data should try to cover all possible types of data). The database will store

Write test data for the following fields in a database (the data should try to cover all possible types of data).

The database will store the following information:

⚫ name of holiday resort

⚫ average daily temperature (a whole number value is used)

⚫ number of hours of sunshine per day (a whole number value is used).

Describe the validation routines that should be written into the database interface to check the above input values are reasonable.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create test data for a database that stores holiday resort information and to describe validation ... View full answer

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 Cambridge IGCSE Computer Science Coursebook Questions!

Q:

True or False. T/F (15 questions, 2 points each, total points 30) 1. Redundancy wastes space because you are storing different types of data in the same place. 2. A database will not only hold...

Q:

CIS 205 Final Project Summer 2018 The final assignment consists of separating a database project into the phases that were outline during the semester. The project should be completed with the...

Q:

SEND PICTURE OF ACCESS FILE Blue Lake Sports is a nationally recognized sporting goods company. It has a growing internship program at its corporate office to offer experience to college students....

Q:

Work on this assignment individually (This is NOT a group assignment). You must submit your source code as one ZIP archive containing both parts of the assignment to the Assignment 1 submission link...

Q:

Advanced level school Python programming. need helps Task 4: elements: 'Physical', 'Fire', 'Ice', 'Lightning', 'Wind', 'Quantum' ' Imaginary' paths : 'Destruction', 'The Hunt', 'Erudition',...

Q:

Functional Requirements You will write a multi-class C++ interfacing prototype system for the Wildlife Zoo that incorporates Java for certain functionalities. The functional requirements for all...

Q:

I need the to do part of the code completed TheZoo.cpp ============================================= #include #include using namespace std; void GenerateData() //DO NOT TOUCH CODE IN THIS METHOD {...

Q:

I need the to do part of the code completed TheZoo.cpp ============================================= #include #include using namespace std; void GenerateData() //DO NOT TOUCH CODE IN THIS METHOD {...

Q:

Elm Manufacturing Company (ELM) is a small manufacturer of back packs located in Rochelle, Minols. They make three different types of Backpacks: of 2 A small backpack made for school that is designed...

Q:

I only need help with TheZoo.cpp all this other java stuff is done (ZooFileWriter.java): the beginning of TheZoo.cpp doesnt need any work either: i dont need help with Animal.cpp/h, or the ones for...

Q:

A video rental store has two video cameras available for customers to rent. Historically, demand for cameras has followed this distribution. The revenue per rental is $40. If a customer wants a...

Q:

Overview you are a consultant who works for the Diligent Consulting Group. In this Case, you are engaged on a consulting basis by Loving Organic Foods. In order to get a better idea of what might...

Q:

Question 1 David has received requests from customers for laptop computers and other related items, sohe has decided that now is the time to expand his computer service business to include the saleof...

Q:

Compute P for the following diagram. 200 150 100 50 0- i= 10%