0
Well, I don't know what yours are, but mine are:
1) Logically correct and complete.
2) Relational integrity
3) Data integrity
#1 means that the database design is correct and complete with regards to the atomization of data and the capture and maintenance of all pertinent information necessary to answer the problem at hand. No more, no less.
#2 means that the relationships between the tables are correct with regards to keys, foreign keys, and relational integrity (no orphans allowed) is enforced correctly.
#3 means that your fields are designed such that incorrect data can not be entered into a value, as much as possible. For example, setting field limits and data masks for special kinds of data to ensure that key stroke errors are caught and relayed back to the user before data is posted to the table. An example of this might be the pattern of a US social security number - we know there are nine digits in a social security number. The best way to ensure that the data is correctly entered is to force only NUMBERS for data entry, and add the "-" dashes progamattically. This way, there is no confusion about "do I enter the dashes or not?". Another data integrity feature is date valuation - only calendar dates may be entered. No Feb 30th, for example. In other words, you want to make your database design as "smart" as possible, to make sure that your data is correct at entry. Make it easy for the user to enter data, and make it hard, if not impossible, to enter bad data.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
What is main difference between dbms rdbms why it is called relational database?
There are mainly three different Database architectures and they are network, hierarchical and Relational. The DBMSystems that follow the Relational architectural concepts are known as RDBMS. This is supposed to be superior in design and performance to the other two and there are, to my knowledge, no functional DBMS following the other two concepts in the market today.
What are the types of database?
There are three database models. The three database models are as follows : 1) relational 2) network data 3) hierarchical
Compare the three level of ansi-sparc?
Conceptual database design is the process of constructing a model based on the enterprise. Logical database design is the process of constructing a specific data model. Physical database design is the process of producing of the database on the secondary storage.
In a relational database, the three basic operations used to develop useful sets of data are?
select, project, and join
List three design goals of ATM?
High EfficientLow costHigh reliable
Give three examples of common paper database?
Microsoft Access: A popular desktop relational database management system designed by Microsoft. MySQL: An open-source relational database management system that is commonly used for web applications. PostgreSQL: An open-source object-relational database system that is known for its robust feature set and extensibility.
Which database is better when we are going to have millions of records?
The mainly used databases are Microsoft SQL Server, Oracle, and MySQL. All three of these are relational databases and could easily handle databases containing millions of records.
Can you group a field twice in excel For example I have the field of states but I want to make multiple 'Region' groups as there are three sets of regions each including all 50 statesin my company?
What you really need is to set it up in a relational database. It is not a good idea to duplicate data or fields, as it can lead to problems. If you have a relational database then you can have each region in one table and the states in another and then set up relations between them. It can be complicated, but it is the better way to do it. Study up on relational databases and in particular many to many relationships as this what you particular scenario needs.
What are three types of dbms?
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
How many types of databases?
There are three kind of database mainly . First is network database it which we consider data is linked to other data by the means of some link.Second is object oriented database, that helps to include features like abstraction, encapsulation etc.Third is Hierarchical database , that follows a simple sequence or hierarchy of data , there are nodes and a main root.
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
Define the Domain term in the context of Relational Model?
Definition: The domain of a database attribute is the set of all allowable values that attribute may assume.Examples: A field for gender may have the domain {male, female, unknown} where those three values are the only permitted entries in that column.
