Database

A Database is a repository for collection of related data or facts. A database contains a collection of related items or facts arranged in a specific structure. The most obvious example of a non computerized database is a telephone directory. Telephone companies now use an electronic database program to produce their printed phone books. Sometimes, we see a specialized phone book that is sorted not only by last name, but by other items such as phone number or street address. These books are easy to produce because the telephone company's electronic database can sort and organize the data in many different ways. Database programs can also sort lists of data, arranging them in alphabetical, numeric, or chronological order and can search or query data with different conditions.

Features of Database

The data in a database should have following features

Shared : Data in a database is sharing among different user and application.
Validity : Data should be correct with respect.
Security : Data should be protected from unauthorized user access.
Non-redundancy : No two data items in a database should represent the same real word entity.
Consistency : Data in a database should be same for all users.

Comments

Important Questions of Data Structure and Algorithm (DSA)

. 1. What is Data structure? Explain different operations to be performed on data structure. 2. Define stack as ADT. Convert P+Q-(R*S/T+U) - V*W into infix expression to postfix. 3. Define Queue. Explain its type with example. 4. Difference between stack and Queue. 5. Difference between Linear Queue and circular Queue. 6. Write an algorithm to enqueue and dequeue data element in a circular queue. 7. Define Linked List. Explain its type. How does double linked List is different from circular linked List. 8. What is recursion and recursive function? write a recursive function to compute Fibonacci number. 9. What is an AVL tree ? Create an AVL tree from the following data: 18, 12, 14, 8, 85, 25, 31, 24, 27 10. Define B-tree? How to insertion and deletions of elements can be done in a B-tree. 11. Create an B-tree from the following Data: ...

BCA Math II old question model solution

. BCA Math II question model 2018: BCA Math II question model 2019: BCA Math II question model 2020:

Define LAN and WAN

. Local Area Network (LAN) A LAN is a network that is used for communicating among computer devices, usually within an office building or home. LAN’s enable the sharing of resources such as files or hardware devices that may be needed by multiple users • • Is limited in size, typically spanning a few hundred meters, and no more than a mile. Is fast, with speeds from 10 Mbps to 10 Gbps. Requires little wiring, typically a single cable connecting to each device. Has lower cost compared to MAN’s or WAN’s. LAN’s can be either wired or wireless. Twisted pair, coax or fiber optic cable can be used in wired LAN’s. Advantages of LAN : The data is transferred at an extremely faster rate in local Area Network. Local area network (LAN) provides higher security. Disadvantages of LAN : Initial cost of installing local area network is quite high. Unauthorized user can access critical data of an organization in case LAN ad...

Computer Engineering

Search This Blog