1/3
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
---|
No study sessions yet.
Place the steps needed to map an ERD to a relational schema in the correct order as explained in the course.
Step 1: Mapping of Regular Entity Types
Step 2: Mapping of Weak Entity Types
Step 3: Mapping of Binary 1:1 Relationship Types
Step 4: Mapping of Binary 1:N Relationship Types
Step 5: Mapping of Binary M:N Relationship Types
Step 6: Mapping of Multivalued Attributes
Step 7: Mapping of N-ary Relationship Types
Natural Join
To be applicable, there must be at least one common column name and type between the two relations being joined.
Describe the Simplified Steps in Database Design
1. Requirements Gathering
2. Create Conceptual (high-level) model (e.g.,
ER model)
3. Choose the appropriate DBMS
4. Map Conceptual model into an
Implementation model (Schema)
5. Refine model and implement the database
Schema(s) using the DBMS Language(s)
tgh
asd