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
0
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

Maths Quiz
Andrea Leyden
C2: Material Choices Test
James McConnell
A2 Geography- Energy Security
sophielee0909
BIOLOGY B1 2
x_clairey_x
Psychology A1
Ellie Hughes
Globalisation Case Studies
annie
Unit 203 Revision: Installation Technology Question Bank No.1
Oliver Balay
“In gaining knowledge, each area of knowledge uses a network of ways of knowing.” Discuss this statement with reference to two areas of knowledge
Julianapabab
1PR101 2.test - Část 8.
Nikola Truong
1PR101 2.test - Část 12.
Nikola Truong