This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.
A database is a collection of information that is organized so that it can do very easily be accessed,managed,and updated. The metadata provide a description of the data characteristics and the set of relationships that link the data found within the database. All kinds of individuals use databases, from teachers recording grades to police officers checking criminal histories, collage and universities use databases to keep records on their student, instructors and course. Organization of all type maintains employee microcomputers are Microsoft access, Corel, paradox and lotus approach. A database management system (DBMS) is the software for creating, modifying, and gaining access to the database. Database management system (DBMS) provides the needed organizational approach to flexible storage and retrieval of large amounts of data. Relationship describes an association among entities. When a single set of data items serves a variety of applications, different programs perceive different relationships between the data items. In the relational model such as identifiers are mapped to primary keys in table .Key attributes are also underlined in a frequently used table structure shorthand notation using a format. It identifies a part record uniquely because no to parts have a same part number. The ERD represents the conceptual database as viewed by the end user. A relational uses two distinct notations to describe table, relationship, and constraints. Entity-relationship diagram are the most popular notation for this purpose.
Define Question 1
In question 1 we want creates a table for student. We want create 4 tables in different ways. This question we want to use database system. In this question we create different types of tables for students. The students create 4 different types of table but we want use same name in the table. And also we want to find primary key for every tables. And than the student find the relationship for every table. The security and recovery from failure is for major importance in database design.
A relationship describes an association among entities. . In this structure, there are no access paths down a hierarchy. Rather, the data element are stored in different tables, each of which consists of rows and columns. The ERD represents the conceptual database as viewed by the end user. Each column is a field. The fields are license number last name, first name, streets, city, state and zip. The next section on database this second notation. In this case, the three tables are related by the license number field. An employee may learn job skills, and each job skill may be learned by many employees.
ANSWEAR FOR QUESTION 1
This table for students. In this student table got student ID, the name,sex,semester.They have different tips of name and ID.In this table got 10 peoples in different names.
This table is for lecturers .They have students phone number for contact for any argent news .And also the lecturers centre also got. The students course also have in the table.
This table for parents. The parents also got parents ID and the salary. If any problem for the students we can contact the parents table.
This table for the casher. If the student pay ready the fees we can search the casher table.In this table have cashier Edythe name, student ID and also fees pay.
RELATIONSHIP BETWEEN TABLE
This is the relationship for the students in student table, lecturer table, parents table and also cashier tables.
DEFINE QUESTION 2
Define for question 2 is we wan create a represent our data for student information in ER and database Microsoft Access. this question is how to create a database Microsoft Access. we wan to show how to create a table in Microsoft Access.
How to create a table in Microsoft Access. First we go to start and press the button to go the Microsoft Access.
An than they show like this and we press the button database. After that we press the create button.
This table is create a table for the student information. We want to create 4 types of tables. If u wan create a new table press view.
After that we can do the table for students like student ID, first name, last name and semester create for this table.
This table for create a lecturer table.This also like student table.
This table is student information table for find primer key.
In this table there ask ââ‚¬Å“do you wan save this tableââ‚¬Â we press YES.
After that parents table we wan to create. In this table have phone num,centre,course.
This table show a relationship for the 4 tables.Anthan we press the add button.
The last table is show a relationship like this.
CONCLUTION & RECOMMEDATION
You can expect that the data you are using or inputting is coming from or being stored in some type of database. To understand database you may want to consider enterprise tools, how they are designed and the effort for do so, and the database architecture. . Updating data in database included adding new records, deleting, existing records and changing information within a records. For database recommendation is easy to preparing tables and the relationships. If to do the table we can choose the Microsoft Access.