b_boy x CLOT
New member
a.Explanation of the system design
The first step of the system design begins by creating four tables named property information, advertising, clients and other properties. Property information table includes information as the follows: property ID, property type, number of bedrooms, price, size of garden, monthly service fee, location, names of school, comments. For advertising tables, it contains information such as customer ID, property ID, media types, frequency, when, cost, advertising agent, contacts, information’s. Table of clients comprises as various information: customer ID, first name, surname, address, home phone number, mobile phone number, and email address, sell property, buy property, property type. In addition, table of other properties embraces data such as Property ID, estate agent, address, and contact number, independent level of use, user accessibility, and expedient report.
The second step is to create queries in order to match the attributes of some specific data. The three queries are fees for apartment, media frequency, and single parent homes.
The third step is to create a relationship model to connect the four tables. The relationship is shown in the electronic MS access by clicking databasetools, and then selects the button relationship.
The final step is to create report for each tables and queries.
b.Demonstration of the security
c.Data entry and deletion, including data entry involving more than one table on a screen
Data entry is illuminated in the four forms in current database systems. By use the four forms, Sudesh Patel of green Estates Ltd can enter a significant number of data into access.
d.Demonstration of other data update facilities
Data update facilities include update queries in Database; this is achieved by changing the information in the query.
e.Demonstration of reporting facilities
The report within database systems can be a useful tool to match the users (i.e. System administrators, clients, employees) requirement for several kinds of information.
f.Close down
The first step of the system design begins by creating four tables named property information, advertising, clients and other properties. Property information table includes information as the follows: property ID, property type, number of bedrooms, price, size of garden, monthly service fee, location, names of school, comments. For advertising tables, it contains information such as customer ID, property ID, media types, frequency, when, cost, advertising agent, contacts, information’s. Table of clients comprises as various information: customer ID, first name, surname, address, home phone number, mobile phone number, and email address, sell property, buy property, property type. In addition, table of other properties embraces data such as Property ID, estate agent, address, and contact number, independent level of use, user accessibility, and expedient report.
The second step is to create queries in order to match the attributes of some specific data. The three queries are fees for apartment, media frequency, and single parent homes.
The third step is to create a relationship model to connect the four tables. The relationship is shown in the electronic MS access by clicking databasetools, and then selects the button relationship.
The final step is to create report for each tables and queries.
b.Demonstration of the security
c.Data entry and deletion, including data entry involving more than one table on a screen
Data entry is illuminated in the four forms in current database systems. By use the four forms, Sudesh Patel of green Estates Ltd can enter a significant number of data into access.
d.Demonstration of other data update facilities
Data update facilities include update queries in Database; this is achieved by changing the information in the query.
e.Demonstration of reporting facilities
The report within database systems can be a useful tool to match the users (i.e. System administrators, clients, employees) requirement for several kinds of information.
f.Close down