In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field

In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 22RQ

See similar textbooks

Similar questions

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period. (515)
You are given a database - MGMT2006_202324S02_Boutique Inc Student File.accdb, containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique INC. (That is, your CC will provide you with the database). You should: 1. Rename the database as MGMT2006_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity 3. Append two (2) new customers, two (2) old customers and two (2) new POS transactions. Be sure to include sales for your two new customers. 4. Create the following queries: a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS
To help out a small company that places students in part-time jobs during the school year, you've been hired to build a database. What method would you use to acquire the user's requirements for the database?
You decided to create a client ID field for the primary key since some clients have the same name as others. Now you need to decide on a name for the field. The field name should make it clear that the field is a unique identifier for each record in order for it to be valuable for others using the database. What field name will help you track the relevant information as you work with this table? a)ClientID . b)PrimaryKey.
Please assist with the following Practie Excersises: You are given a database - MGMT2009_2024_Boutique Inc Student File.accdb, containing Currencies, Sales, and Locations tables to provide some results for MGMT Boutique INC. You should: 1. Rename the database as MGMT2009_Boutique_ is your actual name. 2. Create relationships between pairs of tables and enforce referential integrity (NUMBER 1 & 2 HAVE ALREADY BEEN DONE PLEASE DO NOT ANSWER) PLEASE ANSWER OR ASSIST WITH THE FOLLOWING: (KINDY SHOW AN EXAMPLE possibly using any or your won made up database of how the following is done since the actual database for this task is not avaiable) 3. Append two (2) new customers, two (2) old customers and two (2) new POS transactions. Be sure to include sales for your two new customers. 4. Create the following queries: a. List the names of places from which the company sells. Show all columns in the table. Name this query Q1-SELLING-LOCATIONS b. What is the total sales by…
You have just been hired on as a Database Developer, and your employer has provided you with the option to make use of either a trigger or a procedure in the construction of your database. Please provide an explanation of what triggers are and when it would be most suitable to use them.
You have been given the following specifications of a simple database for a local Gym that keeps record of Trainer, Sessions, and Customers. Give the SQL to create the Session table. You may assume that the Trainer and Customer tables have already been created, and that the TrainerID and CustomerID columns are of the data type VARCHAR2(10). The status of the Session refers to the current state of the Session and can only be Active or Dropped
Why is the foreign key important for the integrity of a database? Can you come up with a scenario to show why it is necessary?
You are given a database containing Customer, Service, Call and Rates tables to provide some results for MMC. (That is, your CC will provide you with the database). You should: 1. Rename the database as MGMT2006_G# , where G# is your group number. 2. Create relationships between pairs of tables and enforce referential integrity. 3. Add TWO new Customers and associate them with a Service. 4. Also add TEN new Calls along with their information for any ten customers. Be sure to include calls for your two additional customers. 5. Create the following queries: a. List the names of customers whose status is disconnected. Name this query Q1 – NOTCONNECTED. b. What is the total duration of calls, pre-paid and post-paid for customers with data-plans and for customers without data-plans? Round the duration to a fixed number with no decimal places. Sort in descending order by duration. Name this query Q2 – CallDuration. c. For each customer who has a post-paid service, show how many of these…
There is a database for managing results of a school. There are different users who use thedatabase to enter, summarize and view results. How can we make sure that students must only view results and must not be able to edit it? What kind of security we need to use in that database and how can we improve it while keeping in mind the limited budget of the school?
After you have secured a position working on a database, you will need to decide whether you will employ a trigger or a process. When is the appropriate time to pull a trigger, and what exactly are those triggers?
please answer DBMS ques asap! AUMarket is a retail company whose database system uses the discretionary access control to manage its data. Jennifer is the DBA of this database system and also the owner of a table called PAYMENT. Jennifer grants SELECT on the table PAYMENT to the database user Lee as follows: GRANT SELECT ON PAYMENT TO Lee; However, Jennifer does not want to grant any privileges on the table PAYMENT to the database user Paul. Paul knows very well about database hacking techniques. If Paul does not have any privilege on PAYMENT but he knows that Lee has the SELECT privilege on PAYMENT, is it possible that Paul can hack the database in order to obtain the information of all records in the table PAYMENT? If impossible, you need to explain why it is impossible. If possible, you need to explain how Paul can obtain the information.