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!
Q.1 Briefly discuss the different layers of ANSI SPARC architecture.
Ans: The three layers of ANSI SPARC architecture are like this:
1. Internal view is at the lowest level of abstraction, closest to the physical storage method employed. It points out how the data will be stored and explains the data structures and access methods to be employed by the database. There is one internal view for the whole database.
2. Global or Conceptual View: At this level of abstraction all the database entities and the relationships between them are included. There is one conceptual view for the whole database.
3. External or User View: The external or user view is at the highest level of database abstraction in which just only those portions of the database concern to a user or application programme are involved. Some external or user views may exist for a specified global or conceptual view.
Explain algorithm of ER To Relational Mapping ? ER-to-Relational Mapping Algorithm: 1) Step 1: Mapping of regular entity types: For each strong entity type E, form a relatio
Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke
1) Information about a bank is about customers and their account. Customer has a name, address which consists of house number, area and city, and one or more phone numbers. Ac
The Enhanced Entity Relationship Diagram (ERD) produced with a drawing or case tool. Your EERD must use a ''standard'' notation style such as Crows Foot or Chen. Please note that t
what is view?explain
1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour. Item-based: Fixed, pedicure, waxing, threading, fa
aggregation
Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am
Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))
What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known
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