Ask a question from expert

Ask now

Document Containing all Code and Screenshot the Slate Drop Box

10 Pages454 Words309 Views
   

Added on  2019-09-13

Document Containing all Code and Screenshot the Slate Drop Box

   Added on 2019-09-13

BookmarkShareRelated Documents
Case StudyPLEASE READ THE FOLLOWING NOTES CAREFULLY BEFORE YOU START: This case study is worth 20% of the course grade, and must be completed in groups of 3 or less(No exception) You must submit a Word document containing all code and screenshot the SLATE drop box on orbefore beginning of the second class, Week 13. All email submissions will be given the grade of zero. All late submissions will also be given a grade of zero-----------------------------------------------------------------------------------------In this case study, you and your team members are asked to design and implement the database component of a software system that could be used by a Registrar's Office of a College. The various screens of the systems are shown in the screen mockups in the Appendix below.More specifically, your tasks are:1.Create a full Entity Relationship Model describing the system2.Design all the necessary tables where all the relevant data can be efficiently stored 3.Write all the SQL code to support the application Pay attention to the following requirements:A course might be offered in multiple sections (Note that on the mockups, a Section is called a “Course Offering” – They are just synonyms). A course (eg DBAS27198) can be offerred in multiple sections (eg., 1145_24828, 1145_24123, etc.). Each section is associated with a specific semester (e.g. Fall 2013, Winter 2014), and an instructor. Students are registered with a Section, never with a course.You must write the SQL code to create courses, sections, and add students to course.You must also write the SQL queries to pull the data from the various tables into the grid formats shown on the mockup pages. (Please note that you might have to join or sub-query yourtables together to produce the grids exactly as shown.)Please feel free to approach the instructor and clarify anything that is unclear about this case study.Remember to treat this case study as a learning challenge and not just a “burden” that you need to get over with. You will learn a lot of useful skills from this project if you treat it as a learning opportunity.
Document Containing all Code and Screenshot the Slate Drop Box_1
Have fun!Appendix: Screen Mockups
Document Containing all Code and Screenshot the Slate Drop Box_2
Document Containing all Code and Screenshot the Slate Drop Box_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Instructions for Submission 4 - SQL.
|3
|553
|270

Work and working lives in a changing business environment - Assessment ID/CIPD_7CO01_21_01
|26
|8243
|405

Work and working lives in a changing business environment Assessment
|30
|9275
|282

MGT524 Research Methods in Business: 2nd Article Annotation (Quantitative)
|9
|2167
|255

Build the database you designed in CA4 - Databases, 2016
|4
|955
|313

Quality Control Circle in Organized Retail Sector in UAE - Carrefour
|23
|2772
|71