Part II – Data Gathering
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
This assignment focuses on the design phase of the Systems Development Life Cycle (SDLC).
Deliverables
After reviewing the case study, create a project overview, which includes your requirement analysis.
Items to be included with your submission
Your submission should contain a Microsoft Word document of at least 2-3 pages, (this does not include 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.
Data Gathering Document
Your assignment should include:
- Utilize audience-specific and influential tone to engage this client and provide an explanation of the sample report you are proposing, why it would be helpful to the gym, and how it can be used to make business decisions. Coordinate your thoughts to synthesize and provide context sustaining database concepts.
- Provide a sample Word or PDF document that shows how the report will be displayed.
- Use advanced formatting features such as flowcharts or graphics, produce professional documentation that includes a copy of your ERD.
- Provide an explanation of the entities and attributes that from the ERD that will be used in the report. This should include data type descriptions and character lengths.
- Sample SQL code 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.