Education | Learn flashcards online

Education (3520 Cards)

All aspects of the project will be covered during

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-cis-336-course-project-latest/

DEVRY CIS 336 ALL WEEK COURSE PROJECT (WEEK 1,3,5 & 7) LATEST
This project is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. Each student will be responsible for designing, developing, and demonstrating the functionality of a database created based on a set of business specifications that you create. At the end of the session, each student will submit a report that includes the logical and physical design of the database and demonstrates the database’s ability to deliver meaningful reports. All aspects of the project will be covered during the week or weeks prior to a deliverable

Tags: DEVRY CIS 336 COURSE, DEVRY CIS 336 COURSE PROJECT LATEST
Source: https://www.devrycourses.com/product/devry-cis-336-course-project-latest/

2622
Cardlink

Your data model will include an entity-relationship diagram

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-cis-336-course-project-task-1-latest/

TASK 1 (DUE AT THE END OF WEEK 3)
Develop a detailed logical model of your database based on your business scenario submitted for Task 0. Your data model will include an entity-relationship diagram (ERD) developed with Microsoft Visio or MySQL and a data dictionary (DD) developed with Microsoft Excel.
Note that your deliverables each week include any revisions to the previous task.
Submit your Task 1 deliverable as a zip file including the following.
•Task 0 proposal (with any revisions or updates)
•Your ERD copied to a Word document that fits on a single 8 x 10 page
•Your DD (Excel file)

Tags: DEVRY CIS 336 COURSE, DEVRY CIS 336 COURSE PROJECT TASK 1 LATEST
Source: https://www.devrycourses.com/product/devry-cis-336-course-project-task-1-latest/

2623
Cardlink

you will populate them with data using MySQL

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-cis-336-course-project-task-2-latest/

TASK 2 (DUE AT THE END OF WEEK 5)
First, make sure to make any necessary revisions to your logical model based on Task 1 feedback. Using MySQL, write the statements to develop a physical model of your database by creating the tables and constraints based on your Task 1 logical model.Be sure to use your ERD and data dictionary and create all constraints appropriately.
Once your tables are created, you will populate them with data using MySQL statements to insert records into the database. You should insert a minimum of five records into each table and more where necessary to ensure that the data in the database is sufficient to allow for each of your reports to be tested.
The result will be a script file that includes statements to

Tags: DEVRY CIS 336 COURSE, DEVRY CIS 336 COURSE PROJECT TASK 2 LATEST
Source: https://www.devrycourses.com/product/devry-cis-336-course-project-task-2-latest/

2624
Cardlink

Your final task is to use your tables for an update

Just Click on Below Link To Download This Course:

https://www.devrycourses.com/product/devry-cis-336-course-project-task-3-latest/

TASK 3 (DUE AT THE END OF WEEK 7)
Your final task is to use your tables for an update and for reports. There are two requirements.
1.You will demonstrate an update that includes two tables and uses a subquery. Make sure to prove that your update executed correctly by showing data in the tables before and after the update.
2.You will also develop at least four meaningful reports. One must include a join, one must use a subquery, and one must use an aggregate function. You need to describe the business requirement of the update and each report. Note that numeric PK values are not often meaningful to a person looking at the report.
You will create a script file that has each of the queries called yourname_task3.txt. You will also document the results of this task in a Word document called yourname_reports.docx to show the result of each query. For the update and each report,

Tags: DEVRY CIS 336 COURSE, DEVRY CIS 336 COURSE PROJECT TASK 3 LATEST
Source: https://www.devrycourses.com/product/devry-cis-336-course-project-task-3-latest/

Get these flashcards, study & pass exams. For free! Even on iPhone/Android!

Education (3520 Cards)