Be compassionate #innerandouterjoin Question: This will make the database “think” that there are two tables. Answer: Self join

Learn from mistakes #normalization Question: What is Partial Function Dependency? Answer: A functional dependency in which one or more nonkey attributes are functionally dependent on part.

Be happy #functionandjoin Question: A SQL join claude combined fields from 2 or more tables in a relational database. Answer: Natural Join

Relax :) #relationalmodel Question: E-R attributes map directly onto the relation Answer: Simple attributes #dqlSELECT Question: Allows you to search for specific data Answer: SELECT statement

Be consistent. #eerd Question: A generic entity type that has a relationship with one or more subtypes Answer: Entity Supertype

Keep going. #erd Question: What is attributes? Answer: Properties or characteristics of an entity or relationship type. #basicsql Question: What is update statement? Answer: Modified data in existing rows.

Be positive. #datamodels Question: One importance of Data Models. Answer: Give an overall view of the database #basicsql Question: What is Naming Convention is for? Answer: It is used to name tables and other database objects.

Take every failure as a lesson. #databaseconcepts Question: What is a DBMS? Answer: Collection of programs andManages the database structure #oracleAPEX Question: What are Oracle Application Express three components? Answer: SQL Workshop, Application Builder & Object Browser