Reference no: EM131043977
Review Exam
Be able to explain, define or identify the following terms:
Entity Table RDBMS
Attribute Relationship Constraint
DDL Tuple Row
Chen Notation Crow's Foot Notation N:M Relationship
Cursor Derived Attributes Cardinality
NULL Mandatory Participation Data redundancy
Data Field ER Model
File Data Model SQL
DML Candidate Key Normalization
Primary Key Foreign Key Composite Key
1:1 Relationships 1:M Relationships Recursive Relationship
aggregate functions Group by Identifier
Join Trigger Relation
Surrogate Key Super Key Index
View Referential Integrity
1st Normal Form 2nd Normal Form 3rd Normal Form
Partial Dependency
Components of a database system
Codd's 8 rules to be a relation
Recognize code for Stored Proc, Function, and Trigger
Modification Anomaly (Three kinds)
Data vs. Information
Unstructured Data vs. Structured Data
Be prepared to write SQL to create a table including an Identity.
Be prepared to write SQL to create a foreign key constraint.
Be prepared to write SQL to solve a problem.
Be prepared to draw a ERD using crowfoot notation.
|
Experience in airlines as a cargo officer
: 1. What do you think about the results of Ms. Duckworth's research? 2. Were you surprised? 3. Do you have any personal experiences that support (or refute) her findings?
|
|
The standard normal curve to the left of these values
: Calculate the area under the standard normal curve to the left of these values:a. z = -1.4 and z = 1.4b. z = -3.0 and z = 3.0
|
|
The amortization of flotation costs reduces taxes
: Five years ago, Northwest Water (NWW) issued $40,000,000 face value of 30-year bonds carrying a 8% (annual payment) coupon. NWW is now considering refunding these bonds. It has been amortizing $4 million of flotation costs on these bonds over their 3..
|
|
Compute flow in each pipe
: Using the HAESTED Methods Software (water cad), and the available base map compute flow in each pipe, the pressure at each node and the HL in each pipe. The following design values should be used
|
|
Write sql to create a table including an identity
: Be prepared to write SQL to create a table including an Identity. Be prepared to write SQL to create a foreign key constraint. Be prepared to write SQL to solve a problem.
|
|
Operating results-current assets and current liabilities
: Quarles Industries had the following operating results for 2015: sales = $28,860; cost of goods sold = $19,510; depreciation expense = $5,060; interest expense = $2,340; dividends paid = $1,200. At the beginning of the year, net fixed assets were $17..
|
|
How much does a share of preferred stock cost today
: E-Eyes.com just issued some new preferred stock. The issue will pay an annual dividend of $29 in perpetuity, beginning 18 years from now. If the market requires a return of 4.3 percent on this investment, how much does a share of preferred stock cost..
|
|
Experiencing rapid growth-what is the projected dividend
: Momsen Corp. is experiencing rapid growth. Dividends are expected to grow at 25 percent per year during the next three years, 15 percent over the following year, and then 8 percent per year indefinitely. The required return on this stock is 14 percen..
|
|
Contemporary approaches to management
: Explain how the four contemporary approaches to management are different from one another. Define "open systems" and describe the internal, competitive, and macroenvironments of an organization.
|