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!
Determine the Three Views of Data
We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed already can have different aspects to reveal if seen from dissimilar levels of abstraction. The term Abstraction is very significant here. Generally it means the amount of detail you want to hide. Any entity can be seen from dissimilar perspectives and levels of complexity to make it a reveal its current amount of abstraction.
In the same manner, the database can also be viewed from dissimilar levels of abstraction to reveal dissimilar levels of details.
Example - ALTER TABLE emp MODIFY (empno NUMBER (7));
Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.
Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit
Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description
Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD
A distributed database is defined as "a collection of multiple logically interrelated database which are physically distributed over a computer network" (a) Give any three advan
Properties of a Transaction A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen
How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with
Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t
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
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