Write definitions using your own words for the first 20 Key Terms on page 142 (C

Question

Write definitions using your own words for the first 20 Key Terms on page 142 (Concepts of Database Management 8th Edition) at the end of Chapter 4. Don't just copy and paste the definition from the book! Please take your time and write it as you write your own assignment that you want 100 grades on it! The definition must be related to the same chapter in the book NOT GENERAL DEFINITION. Do it correctly or leave it please!

Thanks!

key terms:

argument

ALTER TABLE

cascade delete

cascade update

catalog

CHECK

client

client/server system

CREATE INDEX

data macro

defining query

Documenter

DROP INDEX

DROP TABLE

entity integrity

FOREIGN KEY

foreign key

GRANT

index

index key

Explanation / Answer

Pre Requirments: Before starting the definitions you need to get understand that below is the sammple table which we are using to understand the definitions in detail.

Table Name : Sample_Table

1) ALTER TABLE:

Scenario: ALTER TABLE command is used to perform operations like adding column, modifying column(changing the types), droping existing columns in a table/entity.

Example: Add Operation.

ALTER TABLE Sample_Table ADD emp_id int;

2)CASCADE DELETE:

Scenario: CASCADE DELETE operation is used in the below scenarion. when we delete the parent entity entry in a table then automatically child entries also deleted. In most of the cases this will be used in foreign key relation.

Example :

Table 1: Main_Table

Table 2: Child_Table_1

Table 3: Child_Table_2

Main_Table primary key is the foreign key for remaining child tables. When we delete parent entity then automatically child entries also deleted.

3)CASCADE UPDATE:

Scenario: This command is used when cascading referential integrity constraints.

This we usually used in funcations when a user trting to do the operations like remove(delete) or else entity update a key value to which is already

existing as foreign keys point.

4)CATALOG:

Scenario: This catalog consists of definitions of database objects such as base tables, views, synonyms, indexes, users are stored.

5)CHECK:

Scenario: This constraint is used when where we want to limit the the data range that can be placed in a column.

If you define this constraint on a column, Then it will give specfied values.

6)CLIENT:

Scenario: SQL Client willuse when where we want to view the structure of a JDBC components, browse the SQL tables and run the SQL commands.

7)Client-Server:

Scenario: The client-server architecture describes the relationship of client and server in an application.

This will give an options(function) or service to 1 or more clients.

8)CREATE INDEX:

Scenario: Create the indexes in entites(tables). these are mainly used for get the details(data) from the specfied database.

By usig this we will get the specified queries with good speed.

Example:

CREATE INDEX idx_sc_id ON Sample_Table (sc_id);

9)DATA MACRO:

Scenario: These used to give you to add logic to events, which occur in entities/tables operations like adding, updating, deleting info.

10)Define Query:

Scenario: This will execute the specified SQL statement which is mentioned in the DefiningQuery element of an file named it as .edmx.

11)Documenter:

Scenario: This is a database documentation tool automatically generates documentation of an entire SQL Server database.

12)DROP INDEX:

Scenario: The SQL DROP INDEX is used for dropping an existing index from the database system.

To create index on a table the below command is used.

CREATE INDEX emp_index ON Sample_Table (sc_id ASC);

If we want to drop index the below command is used.

DROP INDEX sc_index;

13)DROP TABLE:

Scenario: This command is used to drop an existing table in a database.

Example: DROP TABLE Sample_Table;

14)ENTITY INTEGRITY:

Scenario: Entity integrity is used to refer morphology of the primary key, foreign key.

15)FOREIGN KEY:

Scenario: A FOREIGN KEY is a key used to point(linking) two tables/entites together.

This is in one table that will point to the key(PRIMARY KEY) in another table/entity.

16)GRANT:

Scenario: This command/operator will give us the permissions (privileges) to a wanted user or role, or to all users.

With this they will perform actions on database objects.

Example: The following types of privileges can be granted on the tables.

Delete specific data from a specificied table.

17)INDEX:

Scenario: This will create the index on specific data(column) and specific row of the entity.

Example: CREATE INDEX sc_id ON Sample_Table;

18)INDEX KEY:

Scenario: An index Key is used to find the rows and columns of the table quickly.

Also creates a physical object which can be saved to disk.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.