1,954
19
Essay, 2 pages (450 words)

Individual database design paper

To ensure practical use over a long period of, databases ought to be built with high-level of data integrity and the capability to recover data in the event of hardware failure. Data that has been destroyed or corrupted is useless within a business’s data system structure. ” The database architecture Is the set of specifications, rule, and processes that dictate how data Is stored In a database and how data Is accessed by components of the system (homogeneous. Com). Database architecture type S can be fragmented into three general categories, each of which has numerous subcategories: One Tier, Two Tier which is at the client/server level, and the N Tier which is at the client/server level as well. The Tier One architecture is better suited for a single user and a moderately mall amount of data. It is run on a users local host machine and locates a file that Is stored on that workstation’s hard disk, hence using a particular physical source to access and process data.

For numerous users and applications of a small scale the Tier Two selectiveness architecture is a better fit compared to the Tier One architecture. Users interface with the graphical user interface or (GUI) to interact and transfer data to and from the database server through a network via the structured query language or (SQL). For the larger scaled programs, the N Tier client/server architecture needs to be Implemented. This client/server structure Is able to Increase to Include a mold-level or business level tier, this structure has a server for applications which stores the business logic.

The mold; level tier converts and sends client requests in the form of database queries to the database and converts then sends the data coming from the database into data the client requested and can view. The server and client never truly communicate with one another openly. The database architecture I use at work, I would qualify as Two Tier client/server architecture. When entering or leaving the facility, all personal must have their IDs dead at the card reader positioned at all gates and doors.

This data Is checked against a central database by going through a middle tier to avoid direct communication with the company’s mainframe, both for volume and security means. In a relational database, the data in different tables is mapped with relations. ” Information can be accessed or added without reorganizing the tables. A table can have many records and each record can have many fields” (tech-FAQ. Com). Unlike flat databases, data Integrity Is built Into the model at various levels to ensure the between a pair of tables is valid (Dewey. Barry. ND. Du).

Microsoft Access performs an outstanding Job of strengthening referential reliability with strong standardization protocols that guarantee table informational and definitions interactions.

Thank's for Your Vote!
Individual database design paper. Page 1
Individual database design paper. Page 2
Individual database design paper. Page 3

This work, titled "Individual database design paper" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Individual database design paper'. 9 October.

Reference

AssignBuster. (2022, October 9). Individual database design paper. Retrieved from https://assignbuster.com/individual-database-design-paper/

References

AssignBuster. 2022. "Individual database design paper." October 9, 2022. https://assignbuster.com/individual-database-design-paper/.

1. AssignBuster. "Individual database design paper." October 9, 2022. https://assignbuster.com/individual-database-design-paper/.


Bibliography


AssignBuster. "Individual database design paper." October 9, 2022. https://assignbuster.com/individual-database-design-paper/.

Work Cited

"Individual database design paper." AssignBuster, 9 Oct. 2022, assignbuster.com/individual-database-design-paper/.

Get in Touch

Please, let us know if you have any ideas on improving Individual database design paper, or our service. We will be happy to hear what you think: [email protected]