15MM36P: Relational Data Base Management System Office Mgmt 3rd Sem Syllabus for Diploma DTE Karnataka C15 Scheme

Relational Data Base Management System detail DTE Kar Diploma syllabus for Modern Office Management (MM), C15 scheme is extracted from DTE Karnataka official website and presented for diploma students. The course code (15MM36P), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.

For all other office mgmt 3rd sem syllabus for diploma c15 scheme dte karnataka you can visit Office Mgmt 3rd Sem Syllabus for Diploma C15 Scheme DTE Karnataka Subjects. The detail syllabus for relational data base management system is as follows.

Pre-requisites:

Knowledge of Computers.

Course Objectives:

The Students will be able to;

1. Familiarize the Students with various Concepts of Database and its Uses.
2. Enable the Students to acquire Skills about Database Model.
3. Know the Concept of E.R Diagram and ER Modeling.
4. Understand and Comprehend different SQL Statements or Database Language.

Course Outcomes:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

List of Graded Practical Exercises

1. Using any Open Source Data Modelling tool (MySQL/Rational Rose/ERwin), design and develop a ER diagram for the following Library database. Specify relevant Referential constraints.

BOOK AUTHORS

[BOOK ID AUTHOR NAME]

PUBLISHER

[NAME ADDRESS PHONE]

BOOK COPIES

[BOOK ID BRANCH ID NO COPIES]

BOOK LOANS

[BOOK ID BRANCH ID CARD NO DATE HIRED DUE DATE]

LIBRARY BRANCH

[BRANCH_ID BRANCH NAME ADDRESS]

BORROWER

[CARD NO NAME ADDRESS PHONE]

2. Consider a GRADE_BOOK database in which instructors within an academic department record point earned by individual students in theory classes. The data requirements are summarized as follows:
• Each student is identified by a unique identifier, first and last name and an email address.
• Each instructor teaches certain courses each term. Each course is identified by a course number, a section number and the term in it is taught. For each course he or she teaches, the instructor specifies the minimum number of points required in order to earn letter grades, A, B, C, D and F. For Ex. 90 points for an A, 80 points for a B, 70 points for a C and so forth.
• Students are enrolled in each course taught by the instructor.
• Each course has a number of grading components (such as mid-term exam, final exam, project and so forth). Each grading component has a maximum number of points (100 or 50) and a weight (20% or 10%). The weight of all the grading components of a course is 100.
• Finally, the instructor records the points earned by each student in each of the grading components in each course. For Ex. The student 1234 earns 84 points for a mid-term exam, grading component of the section 2 course CS 2310 in the fall term of 2009. The mid-term exam grading component may have been defined to have a maximum of 100 points and a weight of 20% of the course grade.
3. Create the following tables for a COMPANY database

EMPLOYEE

[Fname Minit Lname Ssn Bdate Address Sex Salary Super ssn Dno]

DEPARTMENT

[Dname Dnumber Mgr ssn Mgr start date]

DEPT_LOCATIONS_

[Dnumber Dlocation]

PROJECT

[Pname Pnumber Plocation Dnum]

WORKS ON

[Essn Pno Hours]

DEPENDENT

[Essn Dependent name Sex Bdate Relationship]

4. Illustrate the use of constraints
1. NOT NULL
2. PRIMARY KEY
3. UNIQUE
4. CHECK
5. DEFAULT
6. REFERENCES
5. DATA MANIPULATION : INSERTING VALUES INTO A TABLE
6. Illustrate the use of SELECT statement
7. Conditional retrieval – WHERE clause
8. Query sorted – ORDER BY clause
9. Grouping the result of query – GROUP BY clause and HAVING clause
10. Aggregate functions in SQL (Count, Sum, Max, Min, Avg)
11. SQL operators(And, Or, Like, Between, In)
12. Query multiple tables using JOIN operation.
13. Write nested and complex queries using multiple tables.
14. Perform UPDATE, ALTER, DELETE, DROP operations on tables
15. Illustrate the use of CREATE VIEW command and manipulating
16. Use COMMIT and ROLL BACK commands
17. Use SAVEPOINT commands
18. GUI
1. To study about various Gambas/Visual Basic (front end) or any other front end tool
2. Design a form to use various tools like label, text, combo box, list boxes, check box, option box, horizontal and vertical scroll bars, etc. Illustrate the above with an example such as survey form, registration form for an event or another other example.
3. Design a menu driven form to process student’s results or a shopping list or any other example.
4. Generate a report for student’s results or employee details or shopping list or any other example.
5. Based on any database specified in Question No. 1, 2 or 3 The application must be menu driven having suitable active controls with database connectivity. Generate different reports as per user requirements.

BOOKS RECOMMENDED:

1. Database Management System by Chatterjee – PHI Learning.
2. Database Management System by Alexis Leon & Mathews Leon
3. Problem – Solving Cases using MS Access by Brandy Mons
4. DBMS a Practical Approach by E R Rajiv Chopra – S Chand Publications.
5. Com Primer – Wrox.
6. Database Management System by Hannur
7. SQL Popcorn by Ghosh – PHI Learning.

Reference Books:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

Suggested list of student activities

Note: The following activities or similar activities for assessing CIE (IA) for 5 marks (Any one)

Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.

1. Each group should do any one of the following type activity or any other similar activity related to the course and before conduction, get it approved from concerned course co-ordinator and programme co-ordinator.
2. Each group should conduct different activity and no repeating should occur.

• Build RDBMS application for processing students’ details such as personal details, results, attendance etc. Use minimum 3-4 tables
• Build RDBMS application for maintain a mini library of CD’s. Use minimum 3-4 tables
• Using any ER diagram modelling tool demonstrate modelling of any database containing 3-4 tables.

Course Delivery:

The course will be delivered through Demonstration and Practices:

Note to IA verifier:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

SCHEME OF EXAMINATION:

1. Lab Record/Graded Exercises 05
2. Writing Steps / Procedure to be followed for one Question from Unit-II 15
3. Execution of the Given Questions 20
4. Viva voce 10

**Evaluation should be based on the screen output only. No hard copy required.

**Change of question is allowed only once. Marks of 05 should be deducted in the given question.

For detail syllabus of all other subjects of BE Office Mgmt, C15 scheme do visit Office Mgmt 3rd Sem syllabus for C15 scheme.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.