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!
Record based Logical Models: Use records as the key data representation components
Examples:
Relational Model: It shows data as well as relationship between data in the form of tables.
Constraints are stored in a meta-data table. This is a very easy model and is based on a proven mathematical theory. This is the most usually used data base model.
Network Model: In this model data is shown as records and relationship as links. A easy network model example is explained in Figure . It shows a sample diagram for such a system. This model is a very good quality model as far as conceptual framework is concerned but is today not used in database management systems.
Self-Join: In a self join a table is joined with itself. Let consider the following sample partial data of EMP table EMPNO ENAME MGRID
What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t
What is known as fudge factor? The number of partitions is enhanced by a small value called the fudge factor, which is usually 20 percent of the number of hash partitions compu
What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a
Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged
What does conceptual design work? A conceptual design involves modelling independent of the DBMS.
Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them. Ans: Entity: An entity is a "thing" or "object" in th
how many hourse have been spent on a certain project
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
Which component is not included in database environment ? A users component is not included in database environment.
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