Database Management - Creating a database
3 important questions on Database Management - Creating a database
There are four stages to entity relationship modelling. name them
1.the identification of entities
2.the identification of relationships between entities
3.the identification of attributes of entities
4.the derivation of tables from this.
2.the identification of relationships between entities
3.the identification of attributes of entities
4.the derivation of tables from this.
Three types of relationships are possible?
1.one to one; one visitor stays at one hotel 1:1
2.one to many; one ski school teaches many visitors 1:M
3.many to many; many tour companies use many hotels M:N
2.one to many; one ski school teaches many visitors 1:M
3.many to many; many tour companies use many hotels M:N
Describe in your own words the differences between a join and a relate.
A join merges two tables physically base don a common attribute. Relate connects two tables virtually, two tables stay seperate, but their information is related to one another based on a common attribute.
Try our study magic for free
a PDF, study it super fast
- No sign up, email or credit card needed!
- AI makes unlimited flashcards
- Get unlimited quizzes and tests
- Ask AI anything
Create a notebook
- No sign up, email or credit card needed!
- Have and keep perfect overview
- Make flashcards, notes and mind maps
- Review, test and score!
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
