Write definitions using your own words for the first 20 Key Terms on page 111 (C
ID: 3585051 • Letter: W
Question
Write definitions using your own words for the first 20 Key Terms on page 111 (Concepts of Database Management 8th Edition ) at the end of Chapter 3. 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 grade on it! Thanks!
key terms:
1-CHAR(n)
2-command
3-compound condition
4-CREATE TABLE
5-DATE
6-DECIMAL(p,q)
7-DELETE
8-FROM clause
9-GROUP BY clause
10-HAVING clause
11-INSERT
12-INTEGER
13-INTO clause
14-ORDER BY clause
15-reserved word
16-SELECT clause
17-simple condition
18-SMALLINT
19-SQL (Structured Query Language)
20- subquery
Explanation / Answer
1-CHAR(n): is use as a data type for table attributes . It means attributes can have n char in it.
2-command : Command is use for SQL command. Command use for used for storing, retrieving, modifying, and deleting data.
There are four type of SQL command: Data definations languange(DDL), data manipulation language(DML), Transactional control languange(TCL),
Data control languange(DCL)
3-compound condition: Compund condition is used to group set of queries together. It used BEGIN....AND to group sql statement in between them.
4-CREATE TABLE : This used to create table in database schema. Example: Create table table_name(different columns name with dayatypes...);
5-DATE : It is used as datatype to store date time stamp.
6-DECIMAL(p,q) : it is used to store datatype with decimal value with p digits before decimal and q digits after decimal.
7-DELETE : delete commmand is used to delete the database objects like table, table columns or other objects.
8-FROM clause : From clause is used with sql command to retrive things from table or view
Example: selete * FROM table_name;
9-GROUP BY clause: This clause is used in select statement to group some columns with each other and return data.
10-HAVING clause : having caluse is same as where clause to give some condition to query but having is used with group by clause.
11-INSERT : Insert is used to add new row in database object. To insert data in table we use insert query.
Example: INSERT INTO TABLE_NAME [ (col1, col2, col3,...colN)] VALUES (value1, value2, value3,...valueN);
12-INTEGER : it is use as numeric data type in databse object where field contain integer value.
13-INTO clause : into clause is use with insert query to add new row in table.
14-ORDER BY clause: The ORDER BY clause is used in a SELECT statement to sort results either in ascending or descending order.
15-reserved word :
16-SELECT clause : select clause is to use to retrive records from table in database.
example: select col1,col2,...colN from table_name;
17-simple condition : condition is used in sql queries to filter data in tables. It is used in where caluse or having clause in sql statement.
18-SMALLINT : It is used as numeric data type in sql statements and storage size is 2 bytes so range is -2^15 to (2^15)-1
19-SQL (Structured Query Language) : It is the languange to communicate with database. It is use with relational database.
20- subquery : sub query is used inside a sql query to give some condtion to first query.In bracket query is subquery.
Example Select salary from employee
where salary < (select MAX(salary) from employee );
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.