Construct an E –R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient of the various tests and examinations conducted. An E – R diagram can be viewed as a graph. What do the following terms mean in terms of the structure of an enterprise scheme. i) The graph is disconnected ii) The graph is acyclic.
or ld
2.a)
.in
III-B-Tech. II-Semester Examination April, 2003 DATA BASE MANAGEMENT SYSTEMS (Electronics and Control Engineering) Time: 3 hours Max. Marks: 70 Answer any five questions All questions carry equal marks --1.a) Explain the difference between physical and logical data independence. Use appropriate figure to highlight your answer. b) What are main difference between a file – processing system and a DBMS.
Show that a relation in 4 NF. is also in BCNF. Consider a relation R with attributes A, B, C, D, E, F, G, H, I, J. Let the following FDs are satisfied by R. A, B C; A D, E; B F; D I, J; F G, H; What are the candidate keys for R? Identify the normal form R giving reasons. Normalize it further.
4.a) b)
Describe multi – ring and multi index files. What is DBTG set and discuss about DBTG CODASYL model.
5.
E – R diagram
nt
Social_ security
uW
3.a) b)
Branch_ name
Customer _ street
Aj
Customer name
Customer
Branch_ city
Assets
Branch
Customer_city
Loan_number Amount CLB
Loan Contd…
Code no: 321353
.. 2..
OR
For the E – R diagram shown in the figure above draw the tree – structure diagram and also give corresponding sample database. Write equivalent tuple relational calculus constructs for Cartesian product, Projection and Selection operations of Relational Algebra.
7.a) b)
Explain about Two – phase locking with its merits and demerits. Compare merits and demerits of logbased and Shadow paging recovery techniques.
8.
Write notes on the following: a) ACID properties. b) Integrity Constraints. c) Generalization and Aggregation.
321353 III-B-Tech. II-Semester Examination April, 2003 ...
Code No.: 321353. III-B-Tech. II-Semester Examination April, 2003 · DATA BASE MANAGEMENT SYSTEMS · (Electronics and Control Engineering) · Time: 3 hours · Max. Marks: 70 · Answer any five questions · All questions carry equal marks · --- · 1.a) Explain the difference between physical and logical data independence.
cos (2пn/N) · b) Show that out put sequence y(n) of an LTI system is the convolution of input · sequence x(n) and the impulse response of the system h(n). c) A digital system is characterized by the following difference equation: · Y(n) = x(n)+ay(n-
III-B.Tech. II-Semester Examination April, 2003 · ADVANCED COMPUTER ARCHITECTURE · (common to Computer Science and Engineering, Computer Science and · Information Technology.) Time: 3 hours · Max. Marks: 80 · Answer and five questions · All questions
IV- B.Tech. II Semester Examination April, 2003 · ARTIFICIAL INTELLIGENCE · ( Electronics and Communication Engg and Computer Science and Engg) · Time: 3 Hours · Max. Marks: 70 ... and all skiers like snow. Mike dislikes whatever Tony likes and likes
b) What are the chief merits of Induction heating? 6. a) Explain the principle of Dielectric heating. b) Discuss the thermal losses that occur in Dielectric heating.
Of what concern would the formal organization structure be to an information · systems designer? 3. âInventory Management System is a vital area of ...
How are network techniques useful to prevent time and cost over runs in project · implementation? 3. What is human resource planning? What are its objectives ...
d) Jade · 5.a) Distinguish between natural pearls and cultured pearls. b) Write about the crystal structure appearance, properties, genesis and occurrence of · Coral. 6. Explain how synthetic diamond and synthetic saphire are manufactured. How do · t
6.a) With the help of flow sheet explain the production of titanium tetrachloride from · Ilmenite. b) Discuss various processes used for the production of ductile titanium. c) Give some uses of Tio2 and titanium medal. 7.a) How are uranium isotopes s
III-B.Tech. II-Semester Examination April, 2003 · CONTROL SYSTEM COMPONENTS · (Electronics and Control Engineering) · Time: 3 hours · Max. Marks: 70 · Answer any five questions · All questions carry equal marks · --- · 1.a) Write a brief note on Gene
Max.Marks:70 · Answer any FIVE questions · All questions carry equal marks · --- · 1. Solve the following equations using Cramer's rule: · x+3y+6z = 2; 3x-y+4z ...
b) What are the various process parameters be considered in improving quality and · productivity in ECM? 3.a) Explain the construction and working of Electro-chemical Deburring and Electro- · Chemical Honing. b) What considerations should be looked i
IV- B.Tech. II Semester Examination April, 2003 · TOOL DESIGN · (Mechanical and Production Engineering) · Time: 3 Hours · Max. Marks: 70 · Answer any Five questions · All questions carry equal marks · - - - · 1.a) Sketch a single point cutting tool a
6. What are the raw materials for (a) PMMA and · (b) Nylons. Briefly explain the method of manufacture, properties and uses of the above · polymers. 7.a) What are the important Thermosetting resins? Describe the production of phenol · formal dehyde r
b) Describe the phenomenon of temper embrittlement. 7.a) Describe Irwin theory of fracture mechanism and also determine the crack · extension force exerted ...
Explain about the following faults in Digital circuits. ... 3.a) Define the terms Fault detection, Fault location, Fault Diagnosis in logic ... combinational circuits.
What is its · maximum discharging capacity? 6. Discuss the problems associated with peak voltmeter circuits using passive · elements. Draw circuit developed by Rabus and explain how this circuit · overcomes these problems. 7. Write short notes on: ·
b) With the help of a circuit explain in simple what is a Cyclo-converter? How it · differs from a full wave converter. 5.a) With a neat circuit diagram and wave forms, explain the operation of a single · phase bridge Cyclo-converter with RL load. b)
2.a) Discuss the manufacture of Nitric acid by Ammonia oxidation process. Draw the · necessary flow diagram. b) Explain the thermodynamic and kinetic considerations involved in the · manufacture of Ammonia. 3.a) Describe the manufacturing process for
Graphically represent and give one example of Newtonian fluid, pseudoplastic, · dilatant, ideal plastic and thyxotropic fluid. b) Through a very narrow gap of ...
IRON PRODUCTION · (Metallurgy and Material Technology) · Time: 3 hours · Max.Marks:70 · Answer any FIVE questions · All questions carry equal marks · --- · 1.a) Discuss occurance of iron ores in brief. b) Explain preliminary treatment of iron ores. 2
SALARY. EFFECTIVE DATE. Gannon, Christine. $15,000. August 20, 2003. Melton, Kimberly ... Business - North. 1.0. June 11, 2003 ... Approve the release of Kathy Nagle, Technology Training Manager at Niles. North, whose position has ...