Midterm Exam Notes

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/3

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

4 Terms

1
New cards

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

2
New cards

Natural Join

To be applicable, there must be at least one common column name and type between the two relations being joined.

3
New cards

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)

4
New cards

tgh

asd