Collaborative Databases is a web database where users store and share photos, videos, recordings, and other personal media with other registered users.
How to access data in a Web Database?
To access the database, you enter search text into the search engine. A Web database usually resides on a database server. A database server is a computer that stores and provides access to a database.
Users provide information to Web databases. Many Web sites request users to enter personal information, such as name, address, telephone number, and preferences, into an e-form (electronic form).
The database then stores this personal information for future use. An organization, for example, may send e-mail messages to certain groups of customers.
How to access data in a Web Database?
To access the database, you enter search text into the search engine. A Web database usually resides on a database server. A database server is a computer that stores and provides access to a database.
Users provide information to Web databases. Many Web sites request users to enter personal information, such as name, address, telephone number, and preferences, into an e-form (electronic form).
The database then stores this personal information for future use. An organization, for example, may send e-mail messages to certain groups of customers.
Database Design Guidelines
1. Determine the purpose of the database.
2. Design the tables or files.
- Design tables or files on paper first.
- Each table or file should contain data about one subject. The Student table, for example, contains data about students.
3. Design the records and fields for each table or file.
- Be sure every record has a unique primary key.
- Use separate fields for logically distinct items. For example, a name could be stored in six fields: Title (Mr.,), First Name, Middle Name, Last Name, Suffix (Jr.,), and Nickname.
-Do not create fields for information that can be derived from entries in other fields.
- Set default values for frequently entered data
4. Determine the relationships among the tables or files.
Role of the Database Analysts and Administrators are responsible for managing and coordinating all database activities.
Database Analyst (DA)
-decides on the proper placement of fields, defines the relationships among data, and identifies users’ access privileges.
1. Determine the purpose of the database.
2. Design the tables or files.
- Design tables or files on paper first.
- Each table or file should contain data about one subject. The Student table, for example, contains data about students.
3. Design the records and fields for each table or file.
- Be sure every record has a unique primary key.
- Use separate fields for logically distinct items. For example, a name could be stored in six fields: Title (Mr.,), First Name, Middle Name, Last Name, Suffix (Jr.,), and Nickname.
-Do not create fields for information that can be derived from entries in other fields.
- Set default values for frequently entered data
4. Determine the relationships among the tables or files.
Role of the Database Analysts and Administrators are responsible for managing and coordinating all database activities.
Database Analyst (DA)
-decides on the proper placement of fields, defines the relationships among data, and identifies users’ access privileges.
Database Administrator (DBA)
-requires a more technical inside view of the data.
-creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.
Role of the Employee as a User
The amount of information available often amazes first-time database users. Instant access to information helps employees perform their jobs more effectively. Today, employees access databases from their office desktop computers, notebook computers, or even smart phones and other mobile devices. The maintenance of a database is an ongoing task that organizations measure constantly against their overall goals.
-requires a more technical inside view of the data.
-creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.
Role of the Employee as a User
The amount of information available often amazes first-time database users. Instant access to information helps employees perform their jobs more effectively. Today, employees access databases from their office desktop computers, notebook computers, or even smart phones and other mobile devices. The maintenance of a database is an ongoing task that organizations measure constantly against their overall goals.