







36 5° D 75° A Caterpillar Ultra High Demolition machine is shown. The distances between points A and B is 12 m, points B and C is 2.8 m, C and D is 8 m, and D and E is 2.5 m. Determine the position vectors r AB r BC r CD , and r DE where r AB is the position vector from point A to point B, and so on. Add these vectors to determine the position vector...
Vectors B, C, and D all have the same length but point in different directions as shown. Each vector is added to Vector A. Arrange the length of the three vector sums from longest to shortest. Longest Shortest Shortest Answer Bank A+B A+D A + C
Consider an instance of relation R below 20 A B С D E 5 5 5 5 5 5 5 5 5 4 5 2 4 2 4 1 4 ي ي اي 5 5 5 4 2 4 4 1 4 2 N What would possibly be a candidate key of relation R? (2 Points) Select one: O AE BC BD CD All of the above. None of the above. O
5. [5 points] Let relation R (A, B, C, D, E) satisfy the following functional dependencies: AB → C BC → D CD → E DE → A AE → B Which one of the following FDs is also guaranteed to be satisfied by R? A. B. BCD → A A-B D. CE → B
Given the following relation schemas and the sets of FD's: a- R(A,B,C,D) F={ABẠC,C7D, D´A, BC+C} b- R(A,B,C,D) F={BẠC, BD, AD>B} C- R(A,B,C,D) F={AB-C, DC+D, CD+A, AD+B} d- R(A,B,C,D) F={AB=C, C+D, D™B, DE} e- R(A, B, C, D, E) F= {AB+C, DB+E, AE>B, CD+A, ECD} In each case, (i) Give all candidate keys (ii) Indicate the BCNF violation Give the minimal cover and decompose R into a collection of relations that are BCNF. Is it lossless? Does it preserve the dependencies?...
A. L=25; K=16
B. L=40; K=10
C. L=16; K=25
D. L=10; K=40
E. L=20; K=20
= VE Lulu owns a firm that produces leggings. The production function is given by Q=2VKVL, so that MPL K and MPK = Q is Lulu's VL VK output, K is capital, L is labor, and MP is the marginal product. The wage (w)rate per worker (L) is $40 per day and rental rate (r) per unit of capital (K) is $10 per day. How...
Consider the following relation R = {A,B,C,D,E} and the following set of functional dependencies F = { A → BC CD → E B → D E → A} F = { A → BC CD → E B → D E → A} Give a lossless, dependency-preserving decomposition into 3NF of schema R
R Consider an instance of relation R below A B C D E 5 5 5 5 5 5 5 5 5 4 5 2 4 5 2 4 1 4 5 5 5 4 2. 5 4 4 1 2 4 2 What would possibly be a candidate key of relation R? (2 points) Select one: AE BC BD CD All of the above. None of the above.
Consider the schema R = (A, B, C, D, E) and let the following set F of functional dependencies holdforR: F = {A -> BC, CD -> E, C -> A, B -> D,} 1) Prove or disprove ADE is in the closure of F. A proof can be made by using inference rules IR1 through IR3. A disproof should be done by showing a relational instance (counter example) that refutes the rule. 2) What are the candidate keys of...
R Consider an instance of relation R below A B C D E 5 5 5 5 5 5 5 LO bs 5 4 5 2 4 5 2 5 5 4 1 4 5 4 2 5 4 4 1 2 4 2 What would possibly be a candidate key of relation R? (2 Points) Select one: O AE BC BD CD All of the above. None of the above.