MCA Project 4#
CUSTOMER CARE MANAGEMENT SYSTEM PROJECT IN ASP NET
BCA MCA Bsc B tech CS information technology
final year project
1. IGNOU BCA-CS-06 Assignment 2011(solved)FRONTEND - C # AND .NET FRAMEWORK
BACKEND - SQL SERVER 2008
BCA MCA Bsc B tech CS information technology
final year project
Synopsis- Available- Click on the Project link above to review
Final report- Available - Click on the Project link to review
2. IGNOU BCA-CS-64 Assignment 2011(solved)
3. IGNOU BCA-CS-65 Assignment 2011(solved)
4. IGNOU BCA-CS-66 Assignment 2011(solved)
5. IGNOU BCA-CS-67 Assignment 2011(solved)
Course Code : CS-06
Course Title : Introduction to DBMS
Assignment Number : BCA (4)-06/Assignment/ 2011
Maximum Marks : 100 (Weightage 25%)
Last Date of Submission : 30th April, 2011/30th October, 2011
There are five questions in this assignment. Answer all the questions. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.
Question 1: What is Normalization? Explain the condition under which a relation needs to be normalized to 3 NF fro3 2 NF with the help of an example? (5 Marks)
Question 2: Compare primary, secondary and clustering indexes. Which of these indexes are dense and which are not? (5 Marks)
Question 3: What is difference between B tree and B+ tree? Why a B+ tree is a better tree structure than a B tree for implementation of an indexed sequential file. (5 Marks)
Question 4: Consider the following employee database schema:
Employee ( ESSN ,ENAME , DOB , DEPT-NO , SALARY)
Dependent (ESSN, DEPENDENT_NAME, RELATION, DOB)
Department (DEPT_NO, DEPT_NAME, MANAGER)
Perform the following queries using SQL (5 Marks)
(a) Find the details of dependent for employee having name ABC.
(b) Find the name of manager of the department in which employee whose ESSN code is 1234
(c) Find the name of all employees whose age is less than 18 years.
(d) Find the DOB of the son of employee having employee code ESSN 5078
Question 5: Describe the benefits of data replication in DDBBMS? What typical units of data are replicated in the process of data replication? (5 Marks)
Course Code : CS-64
Course Title : Introduction to Computer Organisation
Assignment Number : BCA (4)-64/Assignment/ 2011
Maximum Marks : 100 (Weightage 25%)
Last Date of Submission : 30th April, 2011/30th October, 2011
There are three questions in this assignment. Answer all the questions. You may use illustrations and diagrams to enhance your explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.
Questions 1: (covers block 1)
(a) Convert the following numbers as asked: (4 Marks)
(i) Decimal 2501 to Hexadecimal
(ii) Octal 230 to Hexadecimal
(iii) Hexadecimal 59FF to Decimal
(iv) Hexadecimal 67AB to Octal
(b) Assume that a computer represents integers in signed 2’s complementation notation having the size of 8 bits. You may also assume that all the registers used for integer arithmetic are also of 8 bits. Perform the following operations using this computer (the numbers indicated in the operations are decimal numbers). You must indicate the overflow condition, if any. (4 Marks)
(i) Add -39 and -89
(ii) Subtract 49 from 48
(iii) Add 78 and 50
(iv) Subtract -25 from -24
(c) A four bit data 1001 is to be sent across a communication channel. How can SEC code be used to ensure that the data is received correctly at the destination? (6 Mark)
(d) Assume that a number comparator compares two numbers A and B of two bits each. The comparator output two bits – the first one output the result of comparison (1 if same 0 otherwise) and second one output 1 if both A and B are zero, otherwise 1. The partial truth table for the comparator is given below:
Number A Number B Output
Bit 1 Bit 0 Bit 1 Bit 0 Same Zero
0 0 0 0 1 1
0 0 0 1 0 0
0 0 1 0 0 0
0 0 1 1 0 0
0 1 0 0 0 0
0 1 0 1 1 0
…
Complete the truth table and design and draw the combinational circuit using AND-OR-NOT gates for the description given above. (6 Marks)
(e) What is a flip-flop? Explain the characteristics table of S R flip flop. How are master slave flip flops different to simple flip-flops (4 Marks)
(f) Explain the direct cache memory organization with the help of a diagram. In the present day computer L1, L2 and L3 cache is being used. What are these cache memories? Find out their sizes. (4 Marks)
(g) “A disk interrupt is given higher priority than the keyboard interrupt. The main reason for this is the access mechanism of a Magnetic disk.” Is the statement given above correct? Justify your answer. What is the need of RAID? Give specification of a commercial RAID architecture. (4 Marks)
(h) Define the term Direct Memory Access in Computer. What is the need of DMA? Compare DMA with I/O processor. In the present day computer, how I/O devices are connected to CPU/Memory. (4 Marks)
Questions 2: (covers block2)
(a) How does the number of operand addresses in an Instruction Set affect the size of a program on a computer? Find the instruction set for a Pentium processor. What are the key features of its instruction set?
(4 Marks)
(b) Assume a machine whose instructions have only two register operands. The values are loaded the register by a load instruction and results are stored in the memory using a store instruction. Select four best addressing modes for the machine. Give reasons for your selection. (4 Marks)
(c) Consider the instruction Subtract Op1, Op2 where Op1 is a register operand and Op2 is a memory operand. This instruction subtracts the value stored in operand Op2 from the Operand Op1 and stores the result into Op1. Write the sequence of micro-operations that will be required to execute this instruction. You may use various micro-operation cycles and the necessary registers. (6 Marks)
(d) Assume that an 8-bit Register R has the data 10110100. Perform the following operations on the register R: (4 Marks)
(i) Selective Set the higher 4 bits to 0110
(ii) Extract the higher 4 bits
(iii) Make all the bits as Zero in the register using a logical operation
(iv) Insert a value 1110 in the lower 4 bits of the register.
(e) Represent the following floating point numbers using IEEE 754 floating point single precision format.
i) 28.125
ii) -0.000125
(4 Marks)
(f) What is a micro-instruction? Explain the different types of Micro-instructions in a computer. What is a micro program? Explain how a micro-program results in execution of an instruction with the help of an example.
(8 Marks)
Questions 3: (covers block 3)
(a) What is the need of segments in 8086 micro-processor? Explain how the address of an instruction is calculated in 8086 using segment register(s).
(4 Marks)
(b) Explain the CALL, DAA, TEST, RET instructions of 8086 processor with the help of one example each. (4 Marks)
(c) Explain any four indirect addressing modes of 8086 microprocessor with the help of an example of each. (4 Marks)
(d) Explain the process of handling an Interrupt in 8086 microprocessor with the help of an example/ diagram. (4 Marks)
(e) Write a program in 8086 assembly language that finds the length of a string. You may assume that the string is stored in the memory and is terminated by the character $. The calculated length of the string may be stored in a location labeled “Length”. (8 Marks)
(f) Write a program in 8086 assembly language that passes one parameter to a subroutine through a stack. The subroutine return a value 0 in case the value is less than or equal to zero or 1 if value is above zero. Make suitable assumptions, if any.
(10 Marks)
Course Code : CS-65
Course Title : Windows Programming
Assignment Number : BCA(4)-65/Assignment/2011
Maximum Marks : 25
Last Date of Submission : 30th April, 2010/ 30th October, 2011
There are five questions in this Assignment. Answer all the questions. You may use illustrations and diagrams to enhance explanations.
Question 1: Design a database application to maintain BCA Students Examination Records and to generating the Hall Tickets for eligible students using Visual Basic. Provide necessary documentation, reports, screen layouts etc. for the project.
(7 Marks)
Question 2: What is a significance of data control? How are these used? Explain.
(3 Marks)
Question 3: What is the difference between passing by value & passing arguments by reference in Visual Basic 6 Procedures? How declaration is done in either case?
(5 Marks)
Question 4: What are Dynamic arrays? Illustrate using code segments how it can be managed?
(5 Marks)
Question 5: How is password field added in Visual Basic? How can a user execute SQL SELECT WHERE & ORDER BY queries from inside a form?
(5 Marks)
Note: Assumptions can be made wherever necessary.
Course Code : CS-66
Course Title : Multimedia
Assignment Number : BCA (4)-66 Assignment/2011
Maximum Marks : 25
Last Date of submission : 30th April, 2011 (For January Session)
30th October, 2011 (For July Session)
There are five questions in this assignment. Answer all the questions. You may use illustrations and diagrams to enhance explanations.
Question 1: Define the term Multimedia. What is need of multimedia software? List four software used in multimedia industry. (5 Marks)
Question 2: What is collaborative learning? Explain the process of collaborative learning using Multimedia, with an example. (5 Marks)
Question 3: List the hardware and software components essential for professional multimedia application development. Also, justify the purpose and need of each of the hardware components. (5 Marks)
Question 4: Differenciate between the following: (4 Marks)
(a) E-mail and Voice mail
(b) Vector image and Bitmap Image
(c) CD ROM and DVD ROM
(d) Animation and Digital Video
Question 5: Discuss how multimedia can be used for the following application areas:
(6 Marks)
(a) Fashion Industry
(b) Flight and Aviation Institute
(c) Advertisement Industry
Course Code : CS-67
Course Title : RDBMS Lab
Assignment Number : BCA (4)-67/Assignment/ 2011
Maximum Marks : 100
Last Date of Submission : 30th April, 2011/30th October, 2011
Answer all the questions. You may use examples illustrations or diagrams to support your answer. You have to implement the database system using any RDBMS.
A Central University runs from its main campus and a number of associated colleges. The University has several programmes ranging from Diploma (1 year duration), Bachelor’s degree (3 or 4 year’s duration), Post Graduation (2 to 3 years duration) and research degree programmes (2-3 years duration). The structure of each programme is approved centrally. A programme may be offered through the main campus or associated college. The students are registered centrally in a programme and college of his/her choice. The fee is also paid centrally yearly. The final data of admission can be obtained by the colleges through a query to the central database. The University has a centralized examination system. It conducts the examination of the students in various courses of various programmes. For simplicity you may assume that a programme of the University only have three compulsory courses in a year. Perform the following tasks for the University. Please make and state assumptions, if any.
Question 1: (10 Marks)
List the entities, their attributes and relationships for the description and make an ER-diagram for the University. You may use the concept of keys, aggregation, generalisation, cardinality etc. in a proper way.
Question 2: (10 Marks)
Design the suitable RDBMS tables for the ER-diagram so created in question 1. The database design should include keys, foreign keys, constraints and referential integrity constraints.
Question 3: (10 Marks)
Implement the database design that you have created in question 2 using a RDBMS – our advice is that you choose either MySQL or MS ACCESS to do so.
Question 4: (10 Marks)
Create the following data entry form with suitable checks for the database so created.
a) Form for Entry of student information such as enrolment number, name, father’s name, date of birth, programme code (it should be from a list of valid programmes), year of programme, and draft number (for fee).
b) Form for entry of examination results of a course submitted by an examiner. It should be noted that the examiners are sent printed examination sheet called mark list for each subject. The mark list contains printed enrolment number and name of the students and a blank column for entering the marks. A mark list is sorted in the order of enrolment numbers.
Question 5: (10 Marks)
Enter at least 4 sets of records in each table. Enter marks directly in the tables except for the data that can be entered using the data entry form created in question 3.
Question 6: (10 Marks)
Create the following reports for the database you have created. The reports should have proper headings and page numbers and should include totals, if needed.
a) Create the list of students of a college. This list should be sorted in the order of programme and enrolment numbers in that programme.
b) Create an attendance list for a subject in a college.
c) Print the mark list of a subject that needs to be verified.
d) Create the result card for a student.
Question 7: (20 Marks)
Write and run the following SQL queries for your database:
a) Find the details of the programme having the maximum number of students.
b) Find the programme that has the maximum fee. Also find the number of students enrolled in this programme.
c) Find the student who have either failed the subject Database Management System at least once or has not given the examination for this subject. You may assume that this subject is taught in BCA 2nd Year and MCA 1st year.
d) Find the student who has topped in BCA 2nd Year examination.
e) Find the number of programmes run in each college.
Question 8: (20 Marks)
Design two views for the database that you have designed and implemented. One view should be for the University Vice Chancellor who is interested in knowing about the performance of students in various programme and colleges. The other view is for a student who can view only his/her information. Identify on what tables and what fields these two will be allowed to have access. Implement these views or write equivalent queries for the view defining expression using SQL.
No comments:
Post a Comment