Programming & Computer Science Answers

a)    Design the database for your clotting brand company using MS Access. Design tables (as mentioned in part a) with necessary fields (must include primary and foreign keys) and draw the ERD diagram. (Paste the image of ERD diagram using snipping tool in your answer sheet). Use query to fetch any specific information of your interest from more than one table (Paste the complete image using snipping tool in your answer sheet).

Rubrics (Scoring Guide)

- Knowledge = 40%

- Application = 30%

- Synthesis = 30% 

Write a program that takes as input two numbers n (integer) and x (double), and prints arctan(x) evaluated by taking n terms of the Taylor series (using x0 =0):

arctan(x) = x - x ³ /3 + x ⁵ /5 - x ⁷ /7 …

To care of numerical accuracy and rounding off we have created a print(x) function. Please use this to print your final answer. Suppose your answer is in a variable called ans, then print it to screen using “print(ans);” and NOT “cout << ans;”.

Write an assembly program for multiplication of two eight bit no. at 4000H=1BH and 4001H=3AH and save result at 4002H and 4003H.

Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.

As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

Also, what you think that replication of database suitable in the above given scenario?

ATM (Automated Teller Machine) machines are electronic outlets that allow customers to do their basic transactions without interaction of bank’s representative. While programming this ATM in C++, We have created a class named CUSTOMER which stores customer data (i.e. name, NIC, age, address, account balance and transaction history etc.). There is a friend function that wants to access some private information of the class.

GDB Question: 

Being a C++ developer, analyze the whole scenario, what do you think “Does a friend function contradict the rules of Encapsulation?”

Change this Passage into Present Tense (simple, continuous, perfect, perfect continuous) 10  Hagrid was so huge that he parted the crowd easily; all Harry had to do was keep close behind him. They passed book shops and music stores, hamburger restaurants and cinemas, but nowhere that looked as if it could sell you a magic wand. This was just an ordinary street full of ordinary people. Could there really be piles of wizard gold buried miles beneath them? Were there really shops that sold spell books and broomsticks? Might this not all be some huge joke that the Dursleys had cooked up? If Harry hadn’t known that the Dursleys had no sense of humor, he might have thought so; yet somehow, even though everything Hagrid had told him so far was unbelievable, Harry couldn’t help trusting him. “This is it,” said Hagrid, coming to a halt, “the Leaky Cauldron. It’s a famous place.” 

Question Statement

A development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.

Suggest the storage system considering the above mentioned scenario with solid reasoning.

Note: Your answer should not be exceeded than 8 lines.

Create a program that will compute:

1. The area and circumference of a circle. Prompt the user to enter the radius. Use 3.14159 for pi.
2. The area and the perimeter of a rectangle. Prompt the user to enter the length and the width.

• Use the plan you created last week. If need be revise your pseudocode and algorithm to match expect output and Mimir test cases. 
• Once again desk check your pseudocode and algorithm.
• Do not allow for invalid input.
• Allow for positive values only.
• Format to 3 decimal places

• Name file main.cpp
• To Mimir submit: .cpp file
• Submit your pseudocode and desk check along with your code to Mimir in a separate file
• Pseudocode and desk check should be in the format of a pdf, picture, or notepad.
• Include your name, date at the top of the code as a comment.
• Restate project assignment question as a comment
• Include detailed comments throughout your code.

Write a program to convert kilogram to gram and pound.

● Declare an array as a global variable, called kilo with 4 elements.

● In main():

▪ Call function get_input().

▪ Call function convert_gram().

▪ Call function convert_pound().

● In get_input():

 Using for loop, prompt the user to input the values in kilogram and store them in the

array kilo.

● In convert_gram():

▪ Use for loop to convert the values in grams and display the values.

▪ Formula: 1 kg = 1000 g

● In convert_pound():

▪ Use for loop to convert the values in pounds and display the values.

▪ Formula: 1 kg = 2.205 pounds

Write a program to convert kilogram to gram and pound.

● Declare an array as a global variable, called kilo with 4 elements.

● In main():

▪ Call function get_input().

▪ Call function convert_gram().

▪ Call function convert_pound().

● In get_input():

 Using for loop, prompt the user to input the values in kilogram and store them in the

array kilo.

● In convert_gram():

▪ Use for loop to convert the values in grams and display the values.

▪ Formula: 1 kg = 1000 g

● In convert_pound():

▪ Use for loop to convert the values in pounds and display the values.

▪ Formula: 1 kg = 2.205 pounds