vu eng201 Mid Term Subjective Solved Past Paper No.5

vu eng201 Business and Technical English Writing Solved Past Papers

This subjective solved past paper is related to book/course code vu eng201 Business and Technical English Writing which belongs to vu organization. We have 10 past papers available related to the book/course Business and Technical English Writing. This past paper has a total of 10 subjective questions belongs to topic Mid Term to get prepared. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to get prepared for exams by learning subjective questions online on NVAEducatio.

NVAEducation also facilitates users to download these solved past papers with an affordable prices. However, users are not enforced to pay for money, rather they can use credits to buy such stuff on NVAEducation. Users can earn credits for doing some little tasks and then you will be able to use that credits to buy solved past papers on NVAEducation.

Question 1: How to implement one-to-one relationship while designing tables.

Answer:

In this relationship primary key of one entity type has to be included on other as foreign key. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.(Page 143)

Question 2: If there is one super type and there are three subtypes, then how many relations should be created?

Answer:

There should be four relations

Question 3: If we have two entities make it one to one relationship?

Answer:

Be the first to post an answer to earn 100 credits.

Question 4: If we map a unary relationship into relationship and ERD has one to one cardinality then what would be the mapping producer?

Answer:

Be the first to post an answer to earn 100 credits.

Question 5: In which condition a relation in first normal form, automatically turns into the second normal form.

Answer:

Be the first to post an answer to earn 100 credits.

Question 6: In which situation do a recursive relationship exist?

Answer:

This is the situation when any attribute of one entity is associated with another attribute of the same entity.
-or-
When an Entity Type is linked to itself , then is called recursive relationship. (Page 95)

Question 7: Make relation b/w two tables with foreign key with example.
EMP (empId, empName, qual, depId)
DEPT (depId, depName, numEmp)

Answer:

In this example there are two relations; EMP is having record of employees, whereas DEPT is having record of different departments of an organization. Now in EMP the primary key is empId, whereas in DEPT the primary key is depId. The depId which is primary key of DEPT is also present in EMP so this is a foreign key. (Page 133)

Question 8: Name the four basic operations (base operations) in relational algebra.

Answer:

Selection, Projection, Cartesian product, Union, and Set Difference

Question 9: Name the three different kinds of anomalies which can be eliminated through normalization?

Answer: