File Transfer Protocols

Part III – Data Modeling and ERD

Continue to review the following Business Case Study:

Green, G. C. (2005). Greta’s Gym: A Teaching Case for Term-Long Database Projects. Journal Of Information Systems Education, 16(4), 387-390.

Systems Development Life Cycle

In this assignment, you will move on to the implementation phase of the Systems Development Life Cycle, and draft data models and an Entity Relationship Diagram based on the case study and your results from your Data Gathering report completed in Module 02.

Deliverables

After reviewing the case study, create a data model and entity relationship diagram document, which includes your ERD diagram.

Items to be included with your submission

Your submission should contain a Microsoft Word document of at least 3-4 pages, (this does notinclude the cover page, table of contents, and references), you must include ALL items below for your project overview, with headers or page breaks separating each item.

Your submission should include the following:

• Microsoft Word document that is at least 3-4 pages long
  • Title Page containing the project title, your name, and date of the assignment. Resource
  • Contains an entity relationship diagram (ERD), explanation of the entities, attributes, and data types.
  • Updated SQL code (must be saved in *.txt or *.sql format).
  • References Page – Include references and links to your research sources. Use APA documentation style consistently to cite any sources in your research. Resources: Quick Guide on References; Sample SQL code that will be used to begin creating your database and tables in *.txt or *.sql format.

Data Modeling and ERD Document

Your assignment should include:

• Use advanced formatting features such as flowcharts or graphics; produce professional documentation that includes a copy of your ERD. This can be embedded in your Word document as an image or attached to your submission as a JPG or PDF attachment. Use Microsoft Visio or another Data Modeling tool to create an ERD that documents the data required to support Greta’s Gym competitive team processes, as documented in the case. Make sure you include highlighted data from your Data Gathering Document that you created in Module 2.
• Your ERD must be clearly labeled, and should not contain any M:M relationships or multi-valued attributes.
• Follow all standards and practices as we discussed during the lectures.
• Updated sample SQL code based on your ERD that will be used to begin creating your database and tables. Demonstrate your ability to make sophisticated use of information including the case study document, text materials, and other resources. You will utilize file transfer protocols (FTP) to both download and upload files to a website, database, or repository to begin building your database in the next module. Updated sample code must be saved in *.txt or *.sql format.