There are five questions in this Assignment. Answer all the questions. You may use illustrations and diagrams to enhance your explanations.

Question 1: Assume a bookshop has database with the following schema of six relations:
Authors (au_id, au_lname, au_fname, phone, address)
Publishers (pub_id, pub_name, city, state, country)
Sales (stor_id, ord_num, qty, title_id)
Stores (stor_id, stor_name, stor_address, city, state, zip)
Titleauthor (au_id, title_id, royaltyper, au_ord)
Titles (title_id, title, type, pub_id, price, pubdate)

Write the following queries in relational algebra:

i. List the authors first and last names for the book titled ‘Life Without Fear’
ii. List the titles of the books sold at Barnum’s. (stor_name)
iii. Give the last names (au_lname) and au_ids of the authors whose books have sold in the store named Barnum’s. Assign an alias to your answer.
iv. Using your alias from the previous problem, give the last names and au_ids of the authors whose books have not sold in the store named Barnum’s
v. List the titles of books, which have not sold any copies at any store (no books sold at all.)
vi. List the titles of the books, which have only sold at Barnum’s. (Do not list the books, which have not sold anywhere.)
vii. List the titles of the books, which have sold at both Barnum’s and Bookbeat. (Two stor_names)
viii. List the titles and stor_names for each book when the book has sold and the title only (with null for the stor_name) if the book has not sold. (Use an outer join.)
ix. List the stor_ids of the stores which have sold all books published by New Moon Books (pub_name)
x. List the titles of the books, which have sold at all stores.
(5 Marks)

Question 2: Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules? (3 Marks)

Question 3: What is a view? Discuss the difference between a view and a base relation. Explain what happens when a user accesses a database through a view.
(3 Marks)

Question 4: Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS.
(4 Marks)

Question 5: Produce an E-R diagram, which documents the entities, attributes, relationships and cardinality involved in the Life Insurance Management System. Create a relational schema to hold the necessary information. Identify the tables and perform normalization to the tables to the required normal forms.
Note: Assumptions can be made wherever necessary.
(10 Marks)

There are four questions in this assignment. Answer both the questions. You may use illustrations and diagrams to enhance your explanations.

Questions 1:
i) Convert the hexadecimal number ABCDEF to binary and octal.
(1 Mark)
ii) Perform the arithmetic operation (+28) + (-15) in binary using
signed -2’s complement representation for negative numbers.
(1 Mark)

iii) Compare the static RAM with Dynamic RAM.
(1 Mark)

iv) Explain the DMA controller with the help of a block diagram.
What is meant by a block transfer?
(1 Mark)

v) What is the difference between memory mapped Input/Output and
peripheral mapped Input/Output.
(1 Mark)
Questions 2: (i) Draw the 8086’s internal configuration and explain the operation of its components.
(2 Marks)

(ii) What are the advantages of using segment registers in the 8086 microprocessor?
(2 Marks)

(iii) List the unconditional branch instructions in 8086 with examples and explain.

(1 Mark)
Questions 3: (i) Design a 16 bit bus using registers and multiplexers and explain its operation.
(2 marks)

ii) Represent the number (+64.6)10 as a floating point binary number with 24 bits. The normalized fraction mantissa has 16 bits and the exponent has 8 bits.
(2 marks)
iii) Design a BCD counter that counts 0 to 9., 0000, 0001 …. 1001, 0000. Explain its operation by means of a truth table
(3 marks)
Questions 4: i) Write a program in 8086 assembly language to add two 16 digit
packed BCD numbers.
(4 marks)
ii) Write a program in 8086 assembly language to do conversion of a 16 digit unpacked BCD number to a packed BCD number.
(4 marks)

There are ten questions in this Assignment. Answer all the questions. You may use illustrations and diagrams to enhance your explanations.

Question 1: Explain the Visual Basic development environment. Also discuss the basic program structure in Visual Basic.
(2 marks)

Question 2: Explain the need of built-in functions in Visual Basic. List out the various built in functions that are available in the latest version.
(2 marks)

Question 3: Analyze the difference between Local, Module level, and Global Variables. Also explain how ActiveX DLLS are created.
(3 marks)

Question 4: Discuss what constitutes proper code writing conventions in Visual Basic. Also write code in Visual Basic to find square root of a given number.
(3 marks)

Question 5: Explain the Chart control and Grid control in Visual Basic.
(2 marks)

Question 6: Create a form where the user can enter their name into a text box and have the name as output into a label in a different font and color.
(2 marks)

Question 7: Build a form with two drop down lists (combo boxes type 0), one for country name and the other for the name of the President/Head of the countries. When this form is loaded fill the lists from the arrays. If the user pulls down one of the lists and clicks on a country the name of corresponding country President/Head is displayed in the text box of the other list.
(2 marks)

Question 8: Create an application with 2 small picture boxes and one large picture box. Each of the small picture box has a radio button. When a radio button is selected, the corresponding image for that picture box gets placed in the large picture box and a Level is generated with the caption of the selected picture just below the large picture box.
(3 marks)

Question 9: Generate a list (use an array of appropriate dimensions) including name, given name and course and address of 10 students consecutively numbered. Generate a program, which prints all information of the students on request of a number (1 to 10).
(3 marks)

Question 10: Create a form with a picture box. Find some interesting pictures. Use a timer control to cycle the pictures every 2 seconds. The form should close when the picture is clicked.
(3 marks)