Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
First Normal Form and second normal form
First Normal Form (1NF)
A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combination of values.
Second Normal Form (2NF)
A relation is said to be in 2NF f if it is already in 1NF and each attribute fully depends on the primary key of the relation. Speaking inversely, if a table has some attributes which is not dependant on the primary key of that table, and then it is not in 2NF.
what is query processing ,query optimization and performance turring?
When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.
Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000. (SELECT d_name FROM dept WHERE d_code IN (SELECT d_c
What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in
What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is
What is Normalization? Database normalization is a data design and organization method applied to data structures based on rules that help building relational databases. In rel
What are the two main goals of parallelism? Load -balance multiple small accesses, so that the throughput of such accesses enhances. Parallelize large accesses so that the res
Describe different steps of the object-oriented design process. The broad steps of the object-oriented design process are: a. Define context and modes of use of the system
Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t
What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be formed and
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd