0
A database is a collection of information about a particular group, for example students. The person creating the database must decide what fields they need. For a student database, you'd definitely need each student's name, address, city, state, and parent's telephone number. And, depending on your needs, you might want to list at least 1 parent's name. The rest of the fields would depend on the purpose of your database.
Let's say it's a 10th grade science class in which students must do 5 experiments, create a poster for the Table of Elements, prepare 2 class presentations, and write 2 papers (1 being 8 pages and 1 being 10 pages). In addition, you must record which students returned a signed parent's permission slip in order to attend a science Expo in Washington, D.C., plus you wanted to keep track of which students are entered into the Science Fair. Therefore, you'd have at least 13 fields for the items I listed (including the 5 separate fields for experiment1, experiment2, experiment3, etc.)
Add your answer:
Earn +20 pts
Give an example of a field that might be used in a database about students?
Grades
What is a field that might be used in a database about students?
A field that might be used in a database about students is "student ID," which is a unique identifier for each student in the database.
What are the various reasons that lead to the occurrence of NULL values in relations?
A given field in a database table might be for a values that, in certain case, no such values exist or can be determined. For example, in an employee database, a field might be a foreign key to that employee's direct manager. However, in the case of the CEO, there is no such person. In that case, the field would be set to Null.
What does field mean access?
Access is a database, and like a database, it has tables and fields. A table is a group of fields, and a field is likewise a single storage element of a table. For example, if there is a table called "Contacts", it might contain fields such as "First Name", "Last Name", "email", and "Phone." Each field has a limit to the amount and type of data it can contain, and each field can be validated independently of any other field.
What does field mean in access?
Access is a database, and like a database, it has tables and fields. A table is a group of fields, and a field is likewise a single storage element of a table. For example, if there is a table called "Contacts", it might contain fields such as "First Name", "Last Name", "Email", and "Phone." Each field has a limit to the amount and type of data it can contain, and each field can be validated independently of any other field.
What is the use of null in database?
Sometimes, a particular field in a database row has a value that is either unknown or undefined. An example might be the termination date of an employee who is still employed by the company. A date field would not accept any value that was not a valid date but no date has been determined for the field as yet. A null would indicate that.
What is a tuple in a database?
An arbitrary group of fields within a database record. Usually has some meaning in the context of the record. For example a 3-tuple in an address record might be the fields that contain the first, middle and last names of the person in the address field.
What is a database fieldname?
A database stores information like names, address, dates of birth etc. When the database is being designed, headings for these things are create, to store the different parts. These are the fields. "Name" is a field, and it could have the fieldname "Name". The designer will often decide to break the name into a first name and a surname. In that case each field would need a different fieldname. They might use "Fname" and "Sname" for example. "DOB" is often used as the fieldname for the field to store Dates of Birth. When the designers are then working to do queries or other programming with the database, they will use the fieldnames to access the data.
What is an example of a field that might be used in a database about librarians?
the name of the book or the name of the librarian it depends if you mean the library in which case it would be the book title or if your talking about the actual llibrarian then it would be something like their name, age and address
What is a field in a database?
In a doctor's database, there would be several fields. The fields could contain the patient's name, address, telephone or mobile number, their Name,Age,Date of birth,allergies, and the doctor's name. Each thing would have a field of its own. So the patient's name and the doctor's name would be in two separate fields. When the data is viewed, the fields would appear as columns within the data. The fields need to be defined before any data is put in. So you would specify that you want a field for a phone number and a field for a doctor's name etc. when you are designing the database.Key words:Field: A field is in a database, it contains important information.
What is field size in access?
A field is essentially the columns of the table on the database. The size of this depends on what you intend placing in each "box". I.e. a first name field would be set up for 20. This will allow 20 characters in that "box" and each box thereafter. A last name field might have 30 character's, a telephone for a mobile phone for example might need 11 (as most mobile phones use a 11 digits) however, a programmer may "future proof the database by allowing up to 20 characters in that box just in case numbers increase as more phones are used.
Why is quality of Data important?
There is a saying in the database industry - GIGO. It stands for garbage in Garbage out. The point of a database is to maintain data in a way that it has a use. For example, in a business a database might be used for inventory. What good would it be if the database didn't contain the right information on quantity and price. Also when you sell something you would like to have its quantity decremented in the database. If this didn't happen reliably you have a big problem. There are other factors in data quality that might be associated with the precision of the data. For example you might have a piece of data stored as an integer, but find out later that you actual need floating point for more precision in your queries.
