Part I and Part II assignments are to be performed individually by the students. Where as Part III mini project is to be performed in the group of 3 as team work
Part I: Assignments on GUI Design using any front end (VB6, VB.NET, Java, Delphi or equivalent tool.)
1 Build a VB or VC application like basic calculator, editor, games etc. with the GUI design and VB or VC programming.
2 Build suitable GUI by using forms and placing controls on it for any application. (Ex. Students registration for FE admission, railway reservation, online ticket booking, new email user creation etc.). Proper data entry validations are expected.
3 Usage of MDI form for creating a menu and connecting other form.
Above exercises have been specified to give idea/prerequisite learning for the concepts required in defining the problem statement for a front end to a DBMS based system. Front end tools support development of following concepts
Controls ( Text Boxes, Labels, Option & Command buttons, Check Boxes, List boxes & Combo boxes, shapes, Panels, Frames, Rich Text boxes, Scroll bars, Grid control, control arrays, Image & Picture boxes, Message boxes, Progress bar, Tab controls).
Properties ( Use of important properties (Behavior, Layout, Design etc) for every controls on the form.
Events (Click, double click, change, Form Load, Got Focus, Lost Focus, Key pressed).
Programming Components (Data types, variable declarations, control structures).
Overall program development life cycle (Form design, Control & events, packaging and deployment).
Part II: Study of SQL using RDBMS (Oracle/MySql/DB2/Sql Server)
(Instructor will define problem definition for each batch of reasonable complexity such that it facilitates the use of all ER/EER features such as all types of relationships including aggregation, generalization, all types of attributes, strong and weak entities. Mapping of ER diagram to schema design should be implemented at least up to 3NF)
1 ER/ERR Assignment
Design and draw an ER/EER diagram using standard notations for service industry (like Hospital, Airline, hotel, insurance, health case etc) and map this diagram into Database Tables.
2 DDL/DML Assignment
a) Create Database Tables in RDBMS generated in problem 1. (Instructor should see that student’s uses row level and table level integrity constraints, while creating tables).
b) Use DML statements such as INSERT, UPDATE, DELETE to insert the data into tables and to update/delete the data inserted into/from tables if required.
c) Write and execute SQL queries to extract information from the tables. (Instructor should frame problem definition such that it will involve use of text manipulation functions, aggregate functions, group value functions, Date functions, conversion and transformation functions, simple queries and nested queries, renaming of attributes, removal of duplications, creating views etc.)
3 PL/SQL assignments
a. Simple PL/SQL programs using the tables created.
b. Write and execute Triggers. (Instructor will frame appropriate problem definition, so that students study different data types & variables, program control statements).
Part 3: Miniproject on RDBMS and Front End development [16 Hours]
A groups of minimum 2 and maximum 3 students should be formed. This mini project is to done as a team activity.
The mini project will go through following phases:
i) Design the Database (use ER/EER diagrams and Normalization up to 3 NF if
required)
ii) Create at least 5-6 tables using all types of possible constraints, and relationship (foreign key) between them.
iii) Populate the database using SQL insert/creating forms.
iv) Implement suitable functionality related to the project which involves proper data processing.
v) Create triggers and active elements to maintain the integrity of the database and perform appropriate action on database updates.
vi) Develop suitable User Interface using appropriate tools & languages.
vii) Generate at least 3-4 suitable data report related to the functionality of the system with proper heading sub headings and footers.
viii) Group of students should submit the Project Report which will be consist of Title of the Project, Abstract, Introduction, scope, Requirements, Entity Relationship Diagram with EER features, Data Dictionary, Relational Database Design, Database Normalization, Graphical User Interface, Source Code, VB Forms and Data Reports, Testing document, Conclusion.
ix) Students should take software engineering concepts in to consideration for above points. They must maintain a log book of the activities related to the projects.
Reference:Syllabus copy - T E I.T.2008 pattern ( unipune.ac.in )