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!
What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a
How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp
Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.
What is trigger? Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.
Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a
In which format database schema is written ? Data base schema is written in the DDL format.
Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,
Group By clauses • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used
(a) Why did SAP introduce the extended star schema?
Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd