0
A properly designed database could mean many things. Essentially, it all depends on what kind of database a user / webmaster / etc is looking for.
A table (In a database) should have a correct number of collumns. Traditionally, the names of these collumns should be lowercased (But doesn't have to be).
A table (In a database) should have a primary key collumn. A primary key is used to uniquely identify each "row". No two rows cannot have the same primary key - it is unacceptable - therefore no two rows can be mixed up. This also cures many problems people may find in the future.
In website database table values, "yes" and "no" should be replaced with boolean values: TRUE or FALSE, or even 1 and 0.
When working with sensitive information, it's a good option to encrypt it somehow - You never know; someone may hack into the system unnexpectedly. Passwords are good examples of values that should be encrypted.
There are a number of many things that will make a database effective and smooth, but it is ultimately up to the creator and modifier of the database to decide.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
What is data structure in a detail?
Whatever is needed for the task and planed/designed in the database schema.
What is Database maintenance?
Database maintenance is an activity which is designed to keep a database running smoothly.
Marketing Database Design?
form_title=Marketing Database Design form_header=Successful marketing comes from a well-designed database. Have one designed by a professional. What does your business do?=_ What is your budget for the database design?=_ Who is your target audience?=_ When does the database need to be completed?=_
Why is it important to have database?
the database is used to maintain the data properly and it is easy to recover.
What is a transactional database?
A Transactional Database is a DBMS where write operations on the database are able to be rolled back if they are not completed properly.
Why is it important to test a database?
Many applications today rely on a backend database in order to function. If the database is not working properly, then the entire application is typically inaccessible because so much information including logins are stored in the database. Databases should be tested for boundary conditions, stress, function, and structure to ensure that everything is working as designed.
Why is a relational database needed?
A relational database is needed for many things. A relational database is known for collecting and organizing various data items into different charts and pictures.
What is the workgroup database?
In work group database approach , consists 20-25 members those team of people will develop a database of an organization . The work group database is designed to support to maintain database by a group of people.
Why is anomalies required in database?
Anomalies are not required in a database. An anomaly is a inconsistency or a problem. A well designed database should not have any anomalies. If there are some, they can cause problems for the users and for the reliability and efficiency of the database.
Which of these describes a database security problem that occurs when actions of database users are not properly tracked?
Limited audit log settings
What is the MySQLi database driver used for?
The MySQLi database driver is a piece of software that is designed for use with a database. One can download this driver online the MySQL official website.
What does database mean ict?
its organised data and is designed for easy access
