This document includes three assignments. Each assignment is in separate sections of this document, and each assignment is paginated separately. The assignments included in this document are as follows:
Project 3 - Paper discussing database applications:
Project 4 - Paper discussing reasons expand globally: Week Two assignment for unknown course
Project 5 - Paper discussing financial aspects of exporting a product: Week Three assignment for unknown course CIS 319: Week 4: Discussing Database Applications
This paper discusses the use of database applications in a company. The company in this case is a software retail organization that sells software applications in brick and mortar stores and online over the Internet. The company also develops user-specific software applications for large user organizations.
The logical design for a database system shows the grouping of users by organizational structure. In a logical design, the principal concerns are the relationships among the users of the system. The logical design for the system is reflected in an Entity Relationship Diagram (ERD) that is presented as a database schema. It is composed of entities, attributes, and relationships (Dennis & Wixom, 2003).
Entities are the people, places, things, actions, and concepts relevant to a system. Attributes are the data elements that describe the entities (Dennis & Wixom, 2003).
Relationships are the connections that exist among entities. Relationships may be (a) one-to-one, (b) one-to-many, and (c) many-to-many. Many-to-many relationships in a system are undesirable because they tend to confuse relationships within a system (Dennis & Wixom, 2003).
Database management systems may be structured to express the relationships between the data contained in the databases in one of three logical data structures or models (Kendall & Kendall, 1999). These functions are accomplished as follows:
Hierarchical s...