Reference no: EM131049615
Question 1
1.1 What is normalization?
1.2 When is a table in 1NF?
1.3 When is a table in 2NF?
1.4 When is a table in 3NF?
1.5 When is a table in BCNF?
Question 2
2.1 Using the INVOICE table structure shown in table 1, write the relational schema, draw its dependency diagram and identify all dependencies (including all partial and transitive dependencies). You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table uses a composite primary key.)
Table 1
|
Attribute Name
|
Sample Value
|
Sample Value
|
Sample Value
|
Sample Value
|
Sample Value
|
|
INV_NUM
|
211347
|
211347
|
211347
|
211348
|
211349
|
|
PROD_NUM
|
AA-E3422QW
|
QD-300932X
|
RU-995748G
|
AA-E3422QW
|
GH-778345P
|
|
SALE_DATE
|
15-Jan-2006
|
15-Jan-2006
|
15-Jan-2006
|
15-Jan-2006
|
16-Jan-2006
|
|
PROD_LABEL
|
Rotary sander
|
0.25-in. drill bit
|
Band saw
|
Rotary sander
|
Power drill
|
|
VEND_CODE
|
211
|
211
|
309
|
211
|
157
|
|
VEND_NAME
|
NeverFail, Inc.
|
NeverFail, Inc.
|
BeGood, Inc.
|
NeverFail, Inc.
|
ToughGo, Inc.
|
|
QUANT_SOLD
|
1
|
8
|
1
|
2
|
1
|
|
PROD_PRICE
|
$49.95
|
$3.45
|
$39.99
|
$49.95
|
$87.75
|
2.2 Using the initial dependency diagram drawn in question 2.1, remove all partial dependencies, draw the new dependency diagrams, and identify the normal forms for each table structure you created.
2.3 Using the table structures you created in question 2.2, remove all transitive dependencies and draw the new dependency diagrams. Also identify the normal forms for each table structure you created
Question 3
Some Tiny University staff employees are information technology (IT) personnel. Some IT personnel provide technology support for academic programs. Some IT personnel provide technology infrastructure support. Some IT personnel provide technology support for academic programs and technology infrastructure support. IT personnel are not professors. IT personnel are required to take periodic training to retain their technical expertise. Tiny University tracks all IT personnel training by date, type, and results (completed vs. not completed). Given that information, create the complete ERD containing all primary keys, foreign keys, and main attributes.
Question 4
4.1 Explain the following statement: a transaction is a logical unit of work.
4.2 What is concurrency control?
4.3 What are the advantages of DDBMS?
4.4 What are the disadvantages of DDBMS?
Question 5
5.1 Explain the difference between a distributed database and distributed processing
5.2 Describe the different types of database requests and transactions.
5.3 What is the objective of query optimization function?
5.4 What is XML and why is it important?
5.4 What is XML and why is it important?
|
Theoretical astrophysics and stochastic calculus
: You have a 3-year old child, who appears to be brilliant. You think she will clearly get a scholarship to Cal Tech when she graduates high school 12 years from now, where she will get a BA in theoretical astrophysics and stochastic calculus. But, jus..
|
|
Cost of equity dcf
: Cost of Equity: DCF, Summerdale Resort’s common stock is currently trading at $36 a share. The stock is expected to pay a dividend of $3.00 a share at the end of the year (D1 =$3.00), and the dividend is expected to grow at a constant rate of 5% a ye..
|
|
Orders product from supplier
: Malone Corporation orders product from a supplier. Malone has a demand of 4,500 units per year of the product. The order cost that Malone pays each time it places an order is $250. The holding cost per unit per year for the product is $80. What is th..
|
|
Normalization
: Using the INVOICE table structure shown in table 1, write the relational schema, draw its dependency diagram and identify all dependencies (including all partial and transitive dependencies). You can assume that the table does not contain repeating g..
|
|
Occupational differences and cultural differences
: List 10 words that could easily be perceived differently. Choose words that create semantic noise because of general differences, occupational differences, cultural differences, or other kinds of differences. Describe the difference between the words
|
|
Referencing the service-process matrix
: Referencing the Service-Process Matrix select the example below that has low customization and low labor intensity. You are a manager at a retail establishment and you know that customers do not like waiting. Waiting is bad for business and you have ..
|
|
Critical approaches to organizational communication
: In what ways do critical approaches to organizational communication differ from the other approaches we’ve considered so far (classical, human relations, human resources, systems, culture, constitutive)? In your answer, be sure to consider both the p..
|
|
Determine upper and lower control limits
: An automatic filling machine is used to fill 1-liter bottles of cola. The machine’s output is approximately normal with a mean of .91 liter and a standard deviation of .01 liter. Output is monitored using means of samples of 30 observations. Use Tabl..
|