Database Management System Using Ms Access 2010 Page 2
ADVERTISEMENT
1
2Model Paper “DATABASE MANAGEMENT SYSTEM USING
MS ACCESS 2010”
For DIT Semester-I
Annual Examination 2016 & Onward
SUBJECTIVE
(PART-B)
Time: 2:10 hours
Marks: 40
SECTION-I
Q1: Write the short answer to any twelve (12) of the following question. 2x12=24
1. What do you mean by data processing?
2. List some database applications.
3. What is database?
4. What is a key field?
5. What is primary key?
6. What is a field?
7. What is a record?
8. What is a query?
9. What are the differences between a form and a report?
10. What is a macro?
11. What is a module?
12. What is datasheet view?
13. What do you mean by filter?
14. What is lookup field?
15. What are attributes?
16. Define many-to-many relationship.
17. How can you import a table created in another database or other file formats?
SECTION –II
Long Questions
Note: Attempt any two (2) questions.
8X2=16
Q2. Define the followings:
i.
Tuples
ii.
Entities
iii.
Key Attributes and non key Attributes
iv.
Degree and Cardinality
Q3. Write SQL queries for the followings.
i.
Display the employee name, father name, job and hire date of employees, who
hired between 1-Jan-2013, and 15-Feb-2013. Order the query in ascending
order by hire date.
ii.
Display the names of all employees where the third letter of their name in a D.
Q4. Discuss the types of forms with examples. And explain different adding and deleting
controls.
---------------------------------------------------------------------------------------------------------
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education