Week 1 Homework Essay

320 WordsApr 13, 20122 Pages
IT 203 Week 1 Homework 1. A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security. A relational database organizes data into sets of overlapping tables. 2. Business logic is the set of rules that govern an organization’s processes. 3. In a client/server relationship, there are only two machines in the process. The client is responsible for two processes: presentation, and requests. The client, or end user, sends a request for information to the server, which then replies with a response. The client then formats the information in a way that is useful to the user. In the three-tier relationship, the client/server relationship is extended by dividing up the server tasks into two tiers, the application server and data server. The request from the client goes to the application (or logic) server, and the data request is then passed on to the data server. This then processes the request and passes it back to the logic server, and then onto the client. 4. An entity is a thing or object of importance about which data must be captured. Some examples might include employees, orders, or books. 5. Database attributes represent characteristics or values about a database relation (also known as a table). Examples include identification numbers, names, and phone numbers. 6. Exhibit 1-9: POSSIBLE TABLES --- ENTITIES | (RELATED) COLUMNS --- FIELDS | NAME | First, Last, Customer Care Rep | ADDRESS | Street, State, Zipcode, City | INVOICE | Invoice number, Order Date | ITEMS | ItemID number, Description, Quanitity | COST | Cost

More about Week 1 Homework Essay

Open Document