CS403 Midterm Subjective by VU Topper RM

Very Important Topics with Question.

1. Primary keys.
2. 2 database relation.
3. Cardinality symbols.
4. Properties of relation.
5. DFD diagram entities.
6. Three architecture level.
7. Draw context level DFD.
8. Record Data base 3 types.
9. Semantic data model type.

10. 2 architecture levels definition.

11. Procedural and non-Procedural.

12. Properties of context level diagram.

13. ERD diagram between two entities.

14. Disadvantages of file processing system.

15. Attribute, strong and weak entity diagram.

16. traditional file processing related statements.

17. Candidate key alternative key secondary topics.

18. Two inference rules are given write their names.

19. Identify the following statement as valid or

invalid?

20. Write the three names of multiuser DBMS

environment?

21. What are the two main divisions of a traditional

file system?

22. What is the difference between strong entity and

weak entity?

23. Difference between Primary key and alternative

key 2 points?

24. Label each entity of universal system with

maximum cardinality.

25. What is the main difference between an equi-join

and a natural join?

26. Which tool can be use after analyzing a problem

to develop a diagram?

27. Difference between referential integrity and

entity integrity constraints?

28. Write entities 6 entities for ERD on your

University Examination system.

29. Define domain of an attribute. Write its

significance. Also write one Example.

30. If organization is using file server how you can

agree a higher management to use a DBMS brief with

5 points. 31. What is the minimum cardinality for each entity

of the given relationship between customer and item.

32. Given ER of a Student or Department relation,

how would you construct a cross-matrix for it

identify report and attributes yourself?

33. In an ER diagram, what is the main constraint

used for a foreign key? Briefly explain the steps

involved in converting an ER diagram into relational

tables.