Database Management System AU Solution 2023
You can buy complete @2000/- Annamalai MBA Solved Assignment solution at discounted price.
1. Draw the various schemes of baking system and explain the involvement of view levels of data abstraction.
2. Draw an E-R diagram for ordering an item in the inventory control system.
3. Develop a conceptual data model for a Hospital Information System and write a PL/SQL program using oracle to perform the following tasks.
4. Print the patient details – according to room wise.
a) Print the patient details – according to the disease wise.
b) Print the patient details – according to the doctors attending them
c) Consider a real system of your interest and give the skeleton of the development of DSS for that system.
2nd Set of Annamalai MBA Assignment
1. Write a short description of the purpose of PL /SQL procedure. Include simple operating instructions. If the procedure takes any arguments, include a sample input that causes it to execute successfully. If your procedure raises an exception, include instructions on how to get it to raise the exception.
2. Define first, second, and third normal forms when only primary keys are considered. How do the general definitions of 2NF and 3NF, which consider all keys of a relation, differ from those that consider only primary key?
3. What do you mean by PL/SQL? What are the advantages of PL/SQL over SQL? Explain the functions of control loops with examples.
4. Is DBMS usage always advisable or sometimes we may depend on file base systems? Comment on the statement by describing the situation where DBMS is not a better option and file base systems is better.
Also available other individual assignment of Annamalai
- Organizational Behaviour Annamalai Solved Assignment
- Management Information System Annamalai Solved Assignment
- Database Management System Annamalai Solved Assignment
- E-Commerce Annamalai Solved Assignment
- Enterprise Resource Planning Annamalai Solved Assignment
- Data Warehousing and Data Mining Annamalai Solved Assignment
- Software Project Management Annamalai Solved Assignment
- Advanced Web Design Annamalai Solved Assignment
Sample Paper of M.B.A. Information Systems Annamalai University
