0
Each Order Form consists of a number of 'Boxes' which are completed to record individual pieces of information about a single order.
Each Record in a database order table consists of a number of fields which are used to store individual pieces of information about a single order
If you have a filing cabinet filled with lots of Order Forms this is like the Order Table in the database which stores lots of Order Records.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What are the requirements that two relations must satisfy in order to be considered union compatible in a database?
When two or more rows share the same number of columns, and when their corresponding columns share the same (or compatible) domains, they are said to be union-compatible.
Relationship between a database and a table?
A table is contained within the database and consists of columns and rows. A table is meant to store data and, in relational databases, are related to other tables within the same database.
What is Data accuracy in a database?
In a database system, it means validity of your existing data. it refers whether your data is correct or not, only one mistake while entering data can lead it to corrupt data. some protocols are used to get rid of wrong data such as input mask. E.g. while entering "dates" someone can write date in the way 01-02-2012, some other can write the same date in this order 02-01-2012 and it is also can be written in full February 01, 2012. so this can spoil record and also while making query you might get incomplete or wrong data. this is the reason it is most important in a database system.
If we arrange all the one digit odd numbers in ascending order and then in decending order to form five digit number what digit occupies the same place value?
5
How do you compare and order rational numbers?
To order fractions and decimals, you can either write them all in the same form and then compare them, or place them on a number line. Recall that numbers increase in value as you move from left to right along a number line.
Basics of Database?
A database is a list of records, each record contains the same information in the same format as every other record. Using a database enables the user to find one or more records quickly and efficently, and to perform some calculations on the information stored.
What are the relationships that the relational database is named for?
In database theory, a relation is defined as a set of tuples that have the same attributes. A tuple is also known as a row or record.
What are the advantages and disadvantages of hierarchical model databases?
The main advantages of the hierarchical database are:· Performance. Navigating among the records in a hierarchical database is very fast because the parent/child relationships are implemented with pointers from one data record to another. The same is true for the sideways relationships from child to child and parent to parent. Thus, after finding the first record, the program does not have to search an index (or do a table scan) to find the next record. Instead, the application needs only to follow one of the multiple child record pointers, the single sibling record pointer, or the single parent record pointer to get to the "next" record.· Ease of understanding. The organization of the database parallels a corporate organization chart or family tree. As such, it has a familiar "feel" to even nonprogrammers. Moreover, it easily depicts relationships where A is a part of B (as was the case with the order database we discussed, where each item was a part of an order).The main disadvantage of the hierarchical database is its rigid structure. If you want to add a field to a table, the database management system must create a new table for the larger records. Unlike an SQL database, the hierarchical model has no ALTER TABLE command. Moreover, if you want to add a new relationship, you will have to build a new and possibly redundant database structure.
Explain the concept of database record and recordset?
A database record is a single row in a database. A recordset (or cursor) represents a query, and looks like (part of) a record or row. It is actually a row of the query, or virtual table representing the query. When you submit a query that returns data, you create a recordset and the database fills it in with the first record that matches the predicate clause. You do what you need to do with that data. When you need the next record, you fetch the next row, and so on and so forth. Some recordsets represent more than one row at a time. That is up to the database and your program design, but the concept is the same - the recordset is all or part of the resultset from the query.
What is a DJ vinyl?
a dj vinyl is the same thing as a record you would have used in the 60s but the difference is it is usually connected to a computer and that allows you to use the same record for all your song database. Another difference is the fact that a DJ's vinyl would not get ruined when you scratch it whereas an original record would be damaged.
Why is it desirable to enforce the referential integrity rules and entity integrity rules?
Database Management Systems ensure consistent data if the database is modeled using proper referential integrity. For example, if a Customer record is deleted from the system, all Orders and Order Items pertaining to that Customer should ideally be cleaned up. Same thing is true for a specific Order. Such logic need not be in the application, instead you can set up database referential integrity rules to perform these cascading actions automatically for you.
What is the relationship between a record and a field?
A record is a collection of fields that represent a single entity or object. Each field in a record holds a specific piece of information about that entity. Together, records and fields help organize and store data in a structured manner within a database or spreadsheet.
A group of related fields is known as data redundancy?
This statement is incorrect. Data redundancy refers to storing the same piece of data in multiple places, leading to inefficiency and inconsistency. A group of related fields is known as a database or a record in a database.
What is global string?
In a database, it is a string of text that is the same throughout the database.
What is a record on a databases?
a record database is all the information about one particullar thing xx xx A database record is all the info dealing with one particular subject A database record is a row of data in a database table consisting of a single value from each column of data in the table. The data in the columns in a table are all of the same type of data, whereas the rows represent a given instance. Example Table: ============================================================================================================== For the given table above, an example of a column of data would be FirstName. All the values in that column are first names. An example record (or row) would be the record with ID = 2 which represents the record for Thomas Green and contains each field from that row. Properly designed relational databases use "primary keys" to uniquely identify records in a database. The value (or values) that compose the key must uniquely identify the entire row and only that entire row in that table. That primary key can then appear in another table to represent a relationship between that table and another table. In the example above, the ID column would serve as the primary key for the table. Read more: What is a database record
Is a database and a database management system the same why why not?
A database is a collection of data. A database management system controls how those data are collected, stored and retrieved.
What is the Difference between instance and physical database?
The terms instance and database are closely related, but don't refer to the same thing. The database is the set of files where application data (the reason for a database) and meta data is stored. An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the database. A database can be opened (or mounted) by more than one instance, however, an instance can open at most one database.
