Basic questions regarding Database which are very necessary for all.

Asked By 0 points N/A Posted on -
qa-featured

Hi All,

Can you please help me with these questions.
 
  • What is database and relational database?
  • What is a form and filter? And mention its advantages.
  • What do you mean by Table, Record, Field and quires?
  • What is the difference between data and information?
  • What are validation rules and why do we use validation rules?
  • What is the difference between text and memo data type in MS Access?
  • What do you mean by primary key? And describe its advantages.
  • Why are indexes used in table?
  • Why do we relate table?
  • How can we prevent duplicate data to be entered in a field other than using primary key?
 
Thanks a lot.
SHARE
Best Answer by Rock Deen
Best Answer
Best Answer
Answered By 0 points N/A #127897

Basic questions regarding Database which are very necessary for all.

qa-featured

I don't know the answer of all question but what i know i will share. The difference between data and information is the data is any kind of thing about some specific are known as data but the information is that which is organized and are arranged.

The example of that data is that when we are talking about some thing but we don't know the exact name of that thing for example if some one know computer but don't know about laptop and some is talking about laptop then the person who do not know about laptop and will considered it that these data are about computer.

But not actually about computer. And the information is that the person take that and shows the laptop to him. He will understood it clearly.

Thanks.

Answered By 0 points N/A #127898

Basic questions regarding Database which are very necessary for all.

qa-featured

These are answers to your questions:

  1. Database is a collection of related data like a telephone directory or address book. Relational database is collection of relation.
  2. Form is usually used by users to enter data it also displays all the related records. Forms are the window interphase that you usually will ask your user to access when performing data entry in your database. Field is a combination of one or more related characters. It represented one unit of data. Field is smallest unit of data that can be accessed by the user. 
  3. Tables are used to create the data in your database. A collection of related fields as single unit is called record. A table is a two dimensional array of rows and columns. The columns of table represent field and rows represent records. Query is a request to perform an action on the data stored in the database. It is a command that can be given to database for extracting, inserting, deleting and modifying the records.
  4. Data is the input given like we add two digits 2 and 4, this is data and the output we get is information like in this case 2+4=6. So the input which is given by a user is data and the output which computer gives is information.
  5. Validation rule specify the criteria for data entered into the field. If the data entered in field does not meet validation rule, it is not accepted. For example only positive values are allowed, it would be written as >=0.
  6. Text data type is used to store alphabets, digits and special characters. Maximum size of text field is 255 characters. Memo is used o store large amount of data. It can store to 64000 characters.
  7. Primary key is an attribute or sets of attribute in a table that uniquely identifies a record. Primary key uniquely identifies each row in a relation.
Answered By 0 points N/A #127899

Basic questions regarding Database which are very necessary for all.

qa-featured

For the first question, this is very common to database subjects. Actually, when we say database it is just a repository of data or by simple definition just a storage of data. Notepad and MS Word are actually used as database.

Meanwhile, Relational Database is a database model that uses the mathematical concept of a relation – (review your math lesson for that). There are principles to be followed in storing data when using the Relational database.

The two are actually just the same, it is just on the way data are stored. In addition, relational database is the most commonly used model for database system. This is one simple misconception of some about database and relational database.

Answered By 0 points N/A #196929

Basic questions regarding Database which are very necessary for all.

qa-featured

Here is answer of your questions:

  • Database is collection of record. If data is in hard copy(in printed form) then it is called manual database and if it is in computer like in ms excel, ms access we called it electronic database. When tables are related to each for the sake of prevention of duplication of record, easy search, easy management etc. This is called Rational Database.
  • Forms provide Graphical user Interface so that data related task can be performed easily for example in a bank cashier have a form open for online transactions in computer. Forms provides best Interactivity between user and application. Filtering means to make data arrangements accordingly like alphabetically (A-Z) or (Z-A) or biggest number first and smallest in on the last in a column. Filter provides facility in data analysis etc.
  • In MS Access table is main place where data is stored. Tables consists of Rows and columns. Each columns has name also called Field Name  like First Name, Last name etc. Record is collection of related and very specific data like Mr. A information his name, address, phone, email etc this called single record. Queries are questions we want to ask from Database and database gives results on the base of query for example we want to check the results of particular student by giving roll no and then database processes our query and gives results to us. Note query is types in specific way with proper syntax.
  • Data is collection of Raw Facts and figures, which can't directly used until processed. For example we want to build a hostel in a town for students. For this we have to collect data, is there most of the students are outsiders, and suppose we found there are 500 students, so it is called data.  Processed form of data is information. In our example we have 500 students data and when asked how many students wants to live in hostel and answer is 5 students, the 5 is information and clearly obtained from 500 students data. We have to process on data for getting more confined results.
  • Validation rule is defining a rule for user to put specific information only for example, we want that a children can be enrolled in a school if he/she has age more than 5, so when a person tries to enter age of student which is less then 5 computer checks it and stops our entry by messaging please enter age more than 5 years. Validation rules are used to check the user entry either correct or not.
  • When you want enter limited data in a columns may contains 200 characters or less then it is better to choose text data type and if we want to take comments or any long message more than 256 characters there is best to choose memo data type because memo is used for storing more characters.
  • Primary key is main key in a table, used for record recognition. For example by setting Roll no as primary key it is a recognition of particular student and can't allowed to assign same roll no to other student. Primary key makes record unique, It is recognition of record, it is also used for relationship.
  • indexes are used in the table so that searching/updating/deletion of particular record is easy. Index tells which record going to duplicate or not in a table.
  • Mentioned above
  • Answer is in First Bullet
  • there is a option is ms access of Relationship in which you can visually drag and drop field of table to other field of table and access automatically draw a line between tables which shows relationship.
  • there is option of index against each field property  when designing the table. By setting it no duplicate we can prevent it to duplicate.

Hope this is help full to you.

 

Login/Register to Answer

Related Questions