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 data model? Explain object based and record based data models?
Ans: A data model is an abstract model in which describes how data is represented and accessed.
(i) Object based data models: Same to a relational database model, but objects, classes and inheritance are directly supported within database schemas and in the query language
(ii) Record based data models: is a database model based on first-order predicate logic. Its core idea is to elaborate a database as a collection of predicates over a finite set of predicate variables, describing constraints on the possible values and combinations of values.
Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people
Entities Let us first be aware of the question: What are entities? An entity is an object of concern used to show the things in the actual world, e.g., table, car, bo
what is 3nf
Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.
Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab
Define deadlock prevention. Deadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual exclusion, hold and wait, no pre
Create a new user : CREATE USER IDENTIFIED BY Example: //CREATE USER MCA12 IDENTIFIED BY W123 Grant: It is used to give database access permission to users. It is of
Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial
Support by Adding Indexes Multiple indexes can be used to access a data file by multiple access paths. In such a scheme only single copy of the data is consider, only the numbe
How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should
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