Links Related to the questions are given below the Questions. If you want to Get SOLUTIONS of these Questions CLICK HERE

Course Code : CS-06
Course Title : Introduction to DBMS
Assignment Number : BCA(4)-06/TMA/07
Maximum Marks : 10
Last Date of Submission : 15 th April, 2007

This is a tutor marked assignment. There are two questions in this Assignment. Answer all the questions. Question number: 1 carries 7 marks and question number: 2 carries 3 marks weightage. You may use illustrations and diagrams to enhance explanations.

Question 1:

Let us suppose that XYZ University's Administration Office needs a database to handle student’s transcript data. The following are the requirements:

• The database keeps track of each student's name, enrollment no. (E. No.), communication address and phone no., permanent address and phone no., date of birth, sex, class, department, college, major subjects (a 4-char code).
• Some applications need to refer individually to the city, state (2-char abbrv.) and zip code (some use 5-digit, some use 9) of the student’s address. Some applications need to refer to student’s first and last names separately. Enrollment no. should be unique number for each student.
• Each department has a name, a 3-char code, location (main building and room number), office phone, college, and a list of instructors. Many colleges are affiliated to the University. Department names and code are unique, within the university.
• Each instructor has his/her enrolment no., first name and last name.
• The course catalog contains the list of courses that XYZ University offers. Each course has a number (e.g. 543), name, description, credit hours and department. Course numbers are unique within a department, but not unique across the university (so taken together, they are unique). Not every course is offered every semester.
• Each section has a single instructor (first and last names - no team-taught class), semester (1-4) year (2-digit), course number and section number.
• A grade report contains the student's name, E. No, course number and section, letter grade (A, B,C, D, E).

Note: If the above user requirements leave out any important detail, assume that it is handled the way XYZ does things in the real world.

Answer the following questions based on the above requirements and specifications:

• Draw an E-R diagram of the above.
• List all the accompanying attributes/domains (including constraints).
• Convert your E-R diagram to a relational schema:
• Use naming as specified in the E-R diagram.
• Use the format as shown in the example below, including:
• Table name in caps
• List of attributes with primary key underlined
• Foreign key specified with table/attribute it references (with .. cascade, it appropriate)

(7 marks)

Question 2: Discuss the difference between the following file organisations:

• Serial
• Index Sequential file organisation
• Hashed

Compare their storage and access efficiencies and also explain for what type of application they are used.

Course Code : CS-06
Course Title : Introduction to DBMS
Assignment Number : BCA(4)-06/Project/07
Maximum Marks : 15
Last Date of Submission : 30 th April, 2007

This is a project assignment. Submit the documentation, coding, tables and design details. You may use illustrations and diagrams to enhance explanations. Assumptions can be made wherever necessary.

Question 1: Produce an E-R diagram, which documents the entities and relationships involved in the Assets Management System of an Organisation. Create a relational schema to hold the necessary information. Identify the tables, perform normalisation to the tables and fully implement the code with necessary validations using MS-Access/DBASE or any other similar package. Provide necessary documentation and coding for the project.

Course Code : CS-64
Course Title : Introduction to Computer Organisation
Assignment Number : BCA(4)-64/TMA/07
Maximum Marks : 10
Last Date of Submission : 15 th April, 2007

All questions in this tutor marked assignment are compulsory. Question number 1 carries 7 marks and question number 2 carries 3 marks weightage. You may use examples illustrations or diagrams to support your answer.

Question 1:

a) What are 1’s compliment and 2’s compliment representations? Why we need to compliment a number? What are the limitations of 1’s compliment, which leads to introduction of 2’s compliment? Perform following calculation using 1’s compliment and then using 2’s compliment representation.

(5 marks)

(i) 10 – 4 (ii) –10 + 4 (iii) – 4 + 4

b)What are the Hamming error-correcting codes? Explain their utility using an example?

(2 marks)

Question 2:

What are microinstructions? Explain the job of microinstructions and types of microinstructions? How microinstructions are sequenced and executed during machine start up?

(3 marks)

Course Code : CS-64
Course Title : Introduction to Computer Organisation
Assignment Number : BCA(4)-64/Project/07
Maximum Marks : 15
Last Date of Submission : 30 th April, 2007

All questions in this project assignment are compulsory. You may use examples illustrations or diagrams to support your answer.

Question 1:

Three players A,B,C are playing cards in casino , the rules of the game are:

• if all three have card of number <10 they win
• if all three have card of number >10 they loose
• if any two have card of number <10 they loose

Design a digital circuit to implement this gaming scheme?

(7 marks)

Question 2:

a) Write a program in assembly language to check that the input string available in data segment is Palindrome or not?

(5 marks)

b) Write a program in Assembly language to find greatest of three input integers.

(3 marks)

Course Code : CS-65
Course Title : Window Programming
Assignment Number : BCA(4)-65/TMA/07
Maximum Marks : 10
Last Date of Submission : 15 th April, 2007

This is a tutor marked assignment. There are five questions in this Assignment. Answer all the questions. Each question carries equal weightage. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments.

Question 1: Explain the Visual Basic development environment.

Question 2: What are built-in functions? Explain the need of built-in String functions in Visual Basic.

Question 3: What is form? Explain how you can set form properties.

Question 4: What is ToolBar? List different components of ToolBar.

Question 5: What is Data Manager? Explain how database is created for a Visual Basic Application.

Course Code : CS-65
Course Title : Window Programming
Assignment Number : BCA(4)-65/Project/07
Maximum Marks : 15
Last Date of Submission : 30 th April, 2007

There are five questions in this project assignment. Answer all the questions. Each question carries equal weightage. Assumptions can be made wherever necessary. Submit the documentation, coding, screen layouts and design details.

Question 1: Create a form, where, if a button on form is clicked current date is appear into a label. Ask use to change the font type and size of text on label. Read font type and size in two different text boxes and apply it on label displaying current date.

Question 2: Build a form with two drop down lists (combo boxes type 0), one for students and the other for their study center code. When this form is loaded fill the lists from the arrays. If the user pulls down one of the lists and clicks on a student the corresponding study center code is displayed in the text box of the other list.

Question 3: Write a Visual Basic application, which is ask for user first name, middle name, and title and address. It display first character of the first name, first character of the middle name and title on one label and address on another label.

Question 4: Create a "welcome" form" which asks the user their name, then says "Hello Mr./Miss <name>". The user is then given a choice viewing different pictures and thereby accordingly the event takes place as per the option selected. This form should stop by clicking a suitable Command Button.

Question 5: Create a form, which facilitate the user to go to an MS-Excel sheet and prepare their mark-sheet.