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!
Type of views:
Simple views and Difficult Views
Feature
Simple Views
Complex Views
Number of tables
One
One or more
Contain Functions
No
Yes
Contain groups of data
Data Manipulation
IS allowed
Not always
Let us look into some of the examples. To see all the details about existing views in
Oracle:
SELECT* FROM USER_VIEWS;
Normal 0 false false false EN-US X-NONE X-NONE
Need 2 projects completed in 3NF format.
what is union compatable?
Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data
Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs
Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that
Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a
External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d
Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))
Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)
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