Database System Development Life Cycle

Anonymous
timer Asked: Nov 20th, 2018
account_balance_wallet $20

Question Description

After you have analyzed the existing material used by the company for their day-to-day duties, the current Access database, and the additional requirements that the current system does not meet, the following requirements entity/attributes have been compiled:

  • Customer information is tracked using ‘standard’ attributes.
  • A customer may purchase products or services; if they purchase products or services, the following is tracked:
    • Product purchased
    • Date of purchase
    • Total of purchase
  • A supplier may sell products or services; if they sold products or services, the following is tracked:
    • Product sold
    • Date of sale
    • Total of sale
    • Is item purchased available for resale
  • Your company wants to keep the number of tables storing address information to a bare minimum (read this as 1).
  • Customers can be both a "supplier" and "someone that purchased services," and it is not required that they be either.
  • Employee information is tracked using standard attributes.
  • An employee will either be considered customer interfacing or internal support.
  • If the employee is customer facing, the following information is tracked:
    • Customer for interaction (note that a customer will only interface with a single employee)
    • Product specialty
    • Hours of training
    • Commission rate
  • If the employee is internal support, then the following is tracked:
    • Salary
    • Support area
  • An employee can be either customer facing or internal support, but not both.
  • Your company wants to keep the number of tables storing generic employee information to a bare minimum (read this as 1).
  • Finally, the company wants to track products or services offered. This should be a single table with typical attributes that describe inventory.
  • Every customer that either makes a purchase or sells goods to the company must be associated with an employee.
  • Every transaction that a customer makes with the company is stored/tracked, A customer may buy or sell many products, and a product is sold to more than one customer.

Create an enhanced ERD to meet these requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity. Also, ensure that all entities are properly related.

Add your ERD as a screenshot to a Word document, and provide supporting discussion about the need for the enhanced diagram tools and the reasoning behind the multiplicity for the relationships.

Add the enhanced ERD and the discussion about the relationship multiplicity to your project template to the section titled "Database System Development Life Cycle."

Unformatted Attachment Preview

Running Head: ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Advanced Database Systems (CS352-1804B-01) Project Document Shell Antonio Larkin 11/18/18 1 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL 2 Table of Contents Project Outline ................................................................................................................................ 3 The Database Models, Languages, and Architecture...................................................................... 4 3-Level ANSI-SPARC Architecture ........................................................................................... 4 Data Independence ...................................................................................................................... 6 DA and a DBA ............................................................................................................................ 6 Pros of Having a Separate DA and DBA .................................................................................... 7 Cons of Having a Separate DA and DBA ................................................................................... 7 Database System Development Life Cycle..................................................................................... 8 Database Management Systems ...................................................................................................... 9 Advanced SQL .............................................................................................................................. 10 Web and Data Warehousing and Mining in the Business World ................................................. 11 References ..................................................................................................................................... 12 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Project Outline TBD 3 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL 4 The Database Models, Languages, and Architecture It is always a best practice to have a unified database for consistency. It is easy to perform operations on a single database than database scattered in an area. It is also easier to secure a single database than multiple databases. It is also easy to monitor the database and have control over it. 3-Level ANSI-SPARC Architecture The 3 levels of ANSI-SPARC architecture were mainly developed to create independence to various levels of the system and separation of user view. The architecture consists of three levels which are external, conceptual and internal levels. The external level of the database consists of user views which can be modified to suit different users. The level allows the exclusion of data which is not useful to a given user and the user is not allowed to access it. This level provides the independence of user views customizations. Various users can have different customized views accessing the same data without affecting each other. It also helps in hiding the physical details of the database since users do have to deal with the physical storage. The conceptual level defines the type of data been stored in the database as a whole and its relationship. However, this level does not show the way data stored physically. Since this is only one conceptual schema in every database, data integrity is effected at this level (Šikšnys & Pedersen, 2016). The lowest level of the architecture is the internal level and it contains the actual data records, indexes, data fields, and their representation. Each database has only one internal schema. ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL 5 The separation of these levels is important since it allows database administrators to change database structure without affecting views accessed by users. In addition, the internal structure is not affected by changes committed to the physical storages aspects. The file below represent the three levels of ANSI-SPARC architecture. Figure 1: Author's diagram for ANSI-SPARC architecture ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL 6 Data Independence Data independence is part of data transparency and it has to be considered in DBMS since the user applications store data there. Data independence refers to how well user application will work after changes have been committed in the organization and definition of data. Logical data independence refers to how conceptual schema can be modified without even modifying user applications or the definition of external schema. The physical data independence refers to the ability to change internal schema while not making changes to the external schema. DA and a DBA Data administrator is the person who is responsible for controlling data of a particular database in an organization. Database administrators are responsible for the design and controlling the use of a database in an organization. Although both are responsible for managing database they differ when it comes to their responsibilities and required skills. DA is responsible for determining the data to be stored in a database depending on the organization's database. It is not a must for him/her to be a technical person but any know; edge about database technology is an added advantage. DA is most focused on the business use of data and for this reason, he/she is required to contribute requirement gathering and analysis as well as the design phase of the database (Coronel & Morris, 2016). DBA is responsible for creating a database which is fully functional and provides any necessary support during database implementation process.in addition, he/she should have enough knowledge of database technology but it is not a must a DBA to business oriented person. DBA is responsible for designing the database, developing and testing it and make sure it is fully operational. ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Pros of Having a Separate DA and DBA Separating DA and DBA improves the accuracy of the data store and functionality of the database. Both have enough time to perform their tasks. The diversity of ideas is supported by having separate DA and DBA since they will brainstorm together and come up with a reliable database and data. In addition is easy for the two to perform divide and conquer to solve a large problem easily. Cons of Having a Separate DA and DBA Having separate DA and DBA is not cost effective since the organization has to pay two people instead of ones. The DA may lack the knowledge of database technology creating a communication and understanding problem between him/her and database administrator. 7 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Database System Development Life Cycle TBD 8 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Database Management Systems TBD 9 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Advanced SQL TBD 10 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL Web and Data Warehousing and Mining in the Business World TBD 11 ADVANCED DATABASE SYSTEMS PROJECT DOCUMENT SHELL References Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning. Šikšnys, L., & Pedersen, T. B. (2016, July). Solved: Integrating optimization problem solvers into SQL databases. In Proceedings of the 28th International Conference on Scientific and Statistical Database Management (p. 14). ACM. 12 ...
Purchase answer to see full attachment

Tutor Answer

Tutorabby
School: Cornell University

Hope you fine...j...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors