Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js

ER Modeling

Description

Topic 2
Chuck H
Flashcards by Chuck H, updated more than 1 year ago
Chuck H
Created by Chuck H about 6 years ago
1
0
1 2 3 4 5 (0)

Resource summary

Question Answer
What is an attribute? An attribute describes a property of an entity or a relationship. For example, "student" might have the attributes "id, age, major".
Explain what is being conveyed here. What are the constraints? Each employee works in at most one department.
Explain what is being conveyed here. What are the constraints? Each employee can manage at most one department. Each department is managed by at most one employee.
True or false: A weak entity cannot be uniquely identified without the candidate key of its owner entity. False. A weak entity cannot be uniquely identified without the PRIMARY key of its owner entity.
The relationship between an owner entity and a weak entity is ___ to ___. one to many (one owner, many weak entities)
True or false: By default, ISA hierarchies do not enforce covering constraints. True
True or false: By default, overlap between inheriting entities in an ISA hierarchy is allowed. False. Such overlap is disallowed by default.
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

General Knowledge Quiz
Andrea Leyden
Harry Potter Trivia Quiz
Andrea Leyden
Resumo global da matéria de Biologia e Geologia (10.º e 11.º anos)
miminoma
Geography Coastal Zones Flashcards
Zakiya Tabassum
Business Studies Unit 1
kathrynchristie
History - Germany 1918 - 1945
Grace Evans
Theories of Religion
Heloise Tudor
Physics 2
Peter Hoskins
Using GoConqr to learn Spanish
Sarah Egan
1.11 Core Textiles
T Andrews