Ch.4 Part 3

Question 1

What is Structured Query Language(SQL)?

Answer 1

A computer language designed to query data in a relational database
Based on relational algebra and allows a user to query and update the database
Queries allow the user to access, read, and report on desired data but the responsibility of making physical changes to the relational database belongs to the Database Management System
S Q L uses these operators and clauses:
INSERT operator: create new record
SELECT operator: begin a query, most useful operator in S Q L, tells the query which columns (or attributes) of a table should be included in the query
UPDATE operator: update record
DELETE operator: delete existing record

Question 2

What is select statement in SQL?

Answer 2

The select statement is used to begin a query

The select statement tells the query which columns(or attributes) of a table should be included in the query

Question 3

What is From clause in the select statment

Answer 3

Clause added to the select statment

Indicates the name of table(s) from which to retrieve data.

Question 4

What is Select in the select statement

Answer 4

Used to begin a query

Statement tells the query which columns(or attributes) of a table should be included in the query

Question 5

What is the where clause

Answer 5

States the criteria that must be met to be shown in the query results

Question 6

What is group by operator?

Answer 6

Is used with aggregate functions on the query results based on one or more columns

Question 7

What is order by clause?

Answer 7

Identifies which columns are used to sort the resulting data

Without it, the order of rows returned by a SQL query will not be defined.

Question 8

What is select distinct?

Answer 8

Clause selects a column without showing repetitive values

Question 9

What is between?

Answer 9

Operator can be used to specify the end points of a range

Question 10

What is membership operator(IN)?

Answer 10

Allows you to test whether a data value matches the specified target values?

Question 11

What are the six relational operators?

Answer 11

Equal
Not equal
Less than
Less than or equal to
Greater than
Greater than or equal to

Question 12

What are the guidelines for creating queries?

Answer 12

Spell accurately and be case sensitive

Specify AND and OR operations correctly

Tables must be joined properly

Name queries systematically

Choose data fields selectively

Question 13

What is enterprise systems?

Answer 13

Enterprise Resource Planning (E R P) systems.
Commercialized information systems.
Integrate and automate business processes across a firm’s value chain.
Located within and across organizations.
Typically use relational data model.
Primary and foreign keys link the hundreds of tables that form the basis for the enterprise system.

Question 14

Examples of Enterprise Systems

Answer 14

SAP/ERP, Oracle ERP, Microsoft Dynamics

Question 15

What are additional details about Enterprise Systems?

Answer 15

Enterprise Systems:
Serve as the backbone of the company’s internal business processes.
Serve as a connection with the external business processes for supply chain and customer relationship management systems.
Accommodate integration and support of various business processes and information needs.
Give a higher level of internal transparency compared to the typically isolated legacy systems.
Provide informational benefits needed to manage effectively an organization’s business activities.
-Timeliness of information.
-Transparency.
-Enhanced completeness.

Question 16

What are the challenges of implementing an enterprise system?

Answer 16

Integrating:
Various modules within the enterprise system.
With external systems such as the information system of a supplier and/or customer.
With the firm’s own existing legacy systems.
Converting:
Data from existing legacy systems to the enterprise system.
Implementing:
Any big project at a firm.