Inner join is involve in finds and returns compatible data from tables while outer join matching data and some data from the tables. #innerandouterjoin.What is cartesian join and cross join?.-Cross join is returns every row from one table crossed with every row from the second.

Normalization and a way to reduce data or delete unwanted ones.#normalization.-Where the functional dependency belongs to or between?.Attributes.

It is not difficult to understand because of the step by step procedure.#functiondandjoin.-What can be used without GROUP BY clause in SELECT query?.COUNT,MAX,MIN,AVG.

The SELECT statement can retrieve column wise or row wise using the following operation.#dqlSELECT.-What is the use of SELECT?.SELECT is a statement used to retrieve information from a database.

I learn is multi step model for choosing between successors that follows a smooth path from problem identification through solution.#relationalmodel.-How do you understand the rational model?.You need to be wise and think about what to do first.

EER modeling concepts are sufficient for representing any database schemas for database applications.#eerd.What is eer modeling?.-EER modeling is use to constructs and they offer a significant advantage over regular er modeling.

the most simple case you need only specify the table name and the metadata object can also get a listing of tables and reflect the full set. #basicsql .What are Tables and Fields? .it is data stored in the form of rows and columns. columns can be categorized as vertical and rows.

it is a graphical approach to database design .data model that defines data elements and their relationship for specified software.#erd.What is the difference between a weak and a strong entity set?.A strong entity set has a primary key.y. A weak entity set has no primary key.

i think in database is easy to create design.#datamodels.is this you firsts incouter i the database?.-Yes.and i think this is enjoy.

not very complex and easy to understand especially it its better explained well.#databaseconcepts.Do you think sql enviroment is easier for you to understand the further knowledge?.-maybe yes because it needs to be improved so as not to be left behind with further knowledge.

For me it its easy to understand the oracle Apex more, even though they are just a bit of a database.#oracleAPEX.Do you think you can easily understand the oracle apex?.-Yes! Because the teacher makes us understand better.

For me it will be difficult for me in the database because my adoption of knowledge is a bit slow and more language. #databaseconcepts. What do you think the new knowledge you can learn?.-Database manipulation language. And how to write programs with packages, debugging.