Review Questions 1. What are the major steps in a database design? 2. Describe t
ID: 667584 • Letter: R
Question
Review Questions
1. What are the major steps in a database design?
2. Describe the conceptual design.
3. What information do you need to collect for the database design process?
4. How do you collect information needed for the conceptual design?
5. Why is data modeling important in a database development process?
6. What are the abilities IDEF1X has to meet data modeling requirements?
7. What is an entity? Give an example of an entity.
8. Explain the difference between an entity class and an entity instance.
9. What is an attribute? Give an example of an entity with some attributes.
10. What is an identifier? Give an example of an identifier.
11. Explain what a surrogate key is.
12. What is a domain? Give an example of a domain.
13. Describe the identifying relationship and give an example of it.
14. Describe the nonidentifying relationship and give an example of it.
15. Describe the many-to-many relationship and give an example of it.
16. What is a categorization relationship? Give an example of a categorization relationship.
17. Describe the HAS-A relationship.
18. Describe the IS-A relationship.
19. What is cardinality? Give an example of cardinality.
20. What does the letter Z stand for as a cardinality symbol?
21. Describe the recursive relationship. Give an example of the recursive relationship.
22. How do you represent a nonspecific relationship?
Computer Science: Database development and management
Explanation / Answer
1. Steps to follow to develop a database.
What is the purpose of your database?
What tables do you need?
What fields do you need?
2.Describe the conceptual design.
Once all the requirements have been collected and analyzed, the next step is to create a conceptual shema for the database, using a high level conceptual data model. This phase is called conceptual design.
4) How do you collect information needed for the conceptual design?
Conceptual database design involves modelling the collected information at a high-level of abstraction
without using a particular data model or DBMS.
5) Why is data modeling important in a database development process?
A data model is a conceptual representation of the data structures that are required by a database. The data structures include the data objects, the associations between data objects, and the rules which govern operations on the objects.”
7) What is an entity? Give an example of an entity.
Entity are basic object of E-R model . Example
Course is entity name of subject are Entity Types.
8)Explain the difference between an entity class and an entity instance.
Entity class is a collection of entities.
Entity instance is a single ocuurence of an entity type.
9) What is an attribute? Give an example of an entity with some attributes.
An attribute is a property or characteristic of an entity
Ex- Student-Name, Roll No
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.