Case study with SQL and ERD
With the given case study:
After reviewing the case study, create at least 3 queries, 1 report, and final database documentation.
Items to be included with your submission
Your submission should contain a Microsoft Word document of at least 10 – 12 pages, containing all components from Modules 01 through 05, (this does not include the cover page, table of contents, and references), you must include ALL items below for your final project submission, with headers or page breaks separating each item.
Your submission should include the following:
- Title Page containing the project title, your name, and date of the assignment.
- Table of Contents:
- Project Review Document
- Functional Requirements
- Database System Description
- Flowcharts or graphics illustrating the current and future processes
- Data Gathering Document
- At least one sample report. This should include column headers and descriptions, and sample data.
- Entity relationship diagram (ERD), explanation of the entities, attributes, and data types.
- Sample SQL code (must be saved in *.txt or *.sql format).
- Data Modeling and ERD
- Final entity relationship diagram (ERD), explanation of the entities, attributes, and data types.
- Updated SQL code (must be saved in *.txt or *.sql format).
- Relational Tables
- Updated SQL code (must be saved in *.txt or *.sql format) showing primary keys and related tables.
- 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. SQL code must be saved in *.txt or *.sql format.
- Your code must also include comments that describes the purpose of the code. For example:
/*Builds [TABLE NAME] which contains customer information.*/PHP code used to create a web interface to your database. Each PHP web page needs to be in *.php format.
- References Page – Include references and links to your research sources. Use APA documentation style consistently to cite any sources in your research.
Did you include the merchandise table and monetary transactions? Did you include the boys and girls exercises/events, which are different (parallel bars or uneven bars)? Did you include the parents table? If not, then add them to the ERD and SQL. It is not required to input values into your tables. Also, it is not required to generate a query, but you may add those if you like.
Lastly, the instructions say your code must also include comments that describes the purpose of the code. For example:
- /*Builds [TABLE NAME] which contains customer information.*/
PART 2:
Now that you’ve completed your database project and documentation, discuss at least 3 lessons you’ve learned during this process. These lessons can relate to the technical portion of the project or the documentation you’ve developed. What did you find most difficult or challenging? Were there specific helpful resources that you’ve used? What were some methods of troubleshooting any technical issues you’ve experienced?
Your document should be at least 2-3 pages in length.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
