Revision Flashcards
1
Q
DDL basic commands
A
Create
Drop
Rename
Alter
2
Q
DML basic commands
A
-Update
Insert
Merge
3
Q
What r Conceptual designs
A
Conceptual designs include only important entities.
4
Q
Logical design
A
Logical design includes all entities and the relationships between them.
5
Q
Physical design
A
Physical design helps in converting the logical design into the physical form
6
Q
The database development life cycle
A
- Establishing Requirements- the stakeholders and everyone involved is consulted and agrees on how they want the system to be in form of a statement of requirements.
- Analysis
- Design
- Implementation
- Testing
- Maintenance
7
Q
What’s ER diagram
A
Is a flow chart that shows how entities relate to each other within a system
8
Q
Primary key use
A
uniquely identifies a record in the relational database table
9
Q
Foreign key
A
refers to the field in a table which is the primary key of another table.
