0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is difference between object and entity?
A database object is represented as one of the following: database, schema, table, column, primary key, and foreign key A database Entity is: An entity is a thing or object of importance about which data must be captured. All things aren't entities - only those about which information should be captured. Information about an entity is captured in the form of attributes and/or relationships. If something is a candidate for being an entity and it has no attributes or relationships, it isn't an entity. Database entities appear in a data model as a box with a title. The title is the name of the entity.
What are the Three types of relationship in datbase?
ANSWER:The three types of relationships in a database are: One-to-one: Both tables can have only one record on either side of the relationship.One-to-many: The primary key table contains only one record that relates to none, one, or many records in the related table.Many-to-many: Each record in both tables can relate to any number of records (or no records) in the other table.Training course are available for many programs and at all levels including DataBase Managment at your local technical college
Who designs a database?
A database or systems designer will do it. They could also have other roles like being an analyst or a database administrator. Whoever is designing a database may work with people in some of those other jobs, particularly when it is a very large system. If it is a small database, then it is easy to design and somebody with a bit of knowledge of databases can design and create one.
Contrast of database and database system?
A database is simply a collection of pieces of information (data). A text file storing names and phone numbers is a database. A database management system (DBMS) is some software that manages the data within the database such as MySQL. Both the software and the database are considered together when thinking of a DBMS.
What is the architecture of a database system?
The atchiteture of a database system is the design of the database for a given application. In some cases an application may be divided into multiple databases. Each database contains one or more tables, each of which contain one or more fields. Fields within a database contain the data required by the associated application, and the business that uses it. The architecture of a database is the physical design of the datbase, its tables, and associated objects such as Stored Procedures, Triggers, Functions, and routines.
Where can one find information about an object oriented database?
One can find information about an object oriented database in the book 'On Object Oriented Database Systems'. One can also find information about an object oriented database online on the IndiaBix website.
Is a table a collection of records for a single object?
A table in a database contains a collection of records (or rows). Each record contains one or more fields (or columns).
What is the difference between centralize and decentralize database?
A centralized database contains all the data tables in one place which all users access. A decentralized database creates copies of the database design in different areas and any given copy contains only that data which is relevant to its particular users.
What is database object that retrieves specific data from one or more tables and then displays only the data you specified?
Query
What part of database hold only one type of information?
what is type database that holds only one type of information
What can you treat a range of data as a distintinct object in a Excel worksheet?
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
What does the term record mean in database?
A record is equivalent to a row in a database, a collection of fields that are associated.
Which database object is used to view individual records one at a time?
SB
How is security implemented in a relational database?
Security is one of the key concern of a database administrator. Security can be added to the user, object etc. An object (table,views,stored procedures etc) can have multiple permissions. A database administrator can grant revoke permissions to the objects. Security is implemented based on the data sensitiveness also. If there is a table for password, make sure that only it's encrypted and can be accessible through administrator only.
Are there any major similiarities between object oriented databases and relational databases?
In a Object Oriented Database, information is given in the form of objects as used in programming languages. "When database capabilities are combined with object programming language capabilities, the result is an object database management system (ODBMS). An ODBMS makes database objects appear as programming language objects in one or more object programming languages." (http://en.wikipedia.org/wiki/Object_database)"A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how those data are arranged). Common usage of the term "Relational database management system" technically refers to the software used to create a relational database, but sometimes mistakenly refers to a relational database." (http://en.wikipedia.org/wiki/Relational_database)
What database object is used to view individual records one at a time?
input form
What is difference between object and entity?
A database object is represented as one of the following: database, schema, table, column, primary key, and foreign key A database Entity is: An entity is a thing or object of importance about which data must be captured. All things aren't entities - only those about which information should be captured. Information about an entity is captured in the form of attributes and/or relationships. If something is a candidate for being an entity and it has no attributes or relationships, it isn't an entity. Database entities appear in a data model as a box with a title. The title is the name of the entity.
