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 three major types of actions includes databases? Briefly discuss these
The three major types of actions including databases are:
(i) Defining: It includes specifying the data types, structures and constraints of data types, structures and constraints the data to be stored within the database.
(ii) Manipulating: It involves functions such as querying the database to retrieve specific data updating the database to reflect changes within the miniworld and generating reports form data.
(iii) Sharing: It permits multiple users and programs to access the database at the same time.
1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures
read-set(T) : Each data items that are read by a transaction T Timestamps : for all transaction T, the start-time and the end time are reserved for all the three phases.
List the Armstrong's axioms for functional dependencies. What do you understand by soundness and completeness of these axioms? Ans: The Armstrong's axioms are: F1:
Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers. You are to create a table in Access
What are the disadvantages of file-processing system? Ans: The Disadvantages of File-Processing System a. Data redundancy and inconsistency - Data redundancy means not nece
A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev
Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie
Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •
Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP
Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.
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