{"action":"created","issue":{"url":"https://api.github.com/repos/floh1695/assignments/issues/23","repository_url":"https://api.github.com/repos/floh1695/assignments","labels_url":"https://api.github.com/repos/floh1695/assignments/issues/23/labels{/name}","comments_url":"https://api.github.com/repos/floh1695/assignments/issues/23/comments","events_url":"https://api.github.com/repos/floh1695/assignments/issues/23/events","html_url":"https://github.com/floh1695/assignments/issues/23","id":313800566,"number":23,"title":"Week 6 Day 4 - Weekend - University of PROforma - ","user":{"login":"mdewey","id":1793923,"avatar_url":"https://avatars2.githubusercontent.com/u/1793923?v=4","gravatar_id":"","url":"https://api.github.com/users/mdewey","html_url":"https://github.com/mdewey","followers_url":"https://api.github.com/users/mdewey/followers","following_url":"https://api.github.com/users/mdewey/following{/other_user}","gists_url":"https://api.github.com/users/mdewey/gists{/gist_id}","starred_url":"https://api.github.com/users/mdewey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdewey/subscriptions","organizations_url":"https://api.github.com/users/mdewey/orgs","repos_url":"https://api.github.com/users/mdewey/repos","events_url":"https://api.github.com/users/mdewey/events{/privacy}","received_events_url":"https://api.github.com/users/mdewey/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-04-12T16:27:33Z","updated_at":"2018-04-26T13:00:00Z","closed_at":"2018-04-25T23:09:40Z","author_association":"NONE","body":"# University of PROforma\n\nYou are tasked with making a database diagram, database, and 2 console applications \n\nThe database will have _at least_ the following entities, and the following columns: \n\n- Courses\n  - Number\n  - Level\n  - Name\n  - Room\n  - Start Time\n\n- Professors\n  - Name\n  - Title (Mr/Ms/Dr, etc...)\n  \n- Students\n  - FullName\n  - Email\n  - PhoneNumber\n  - Major\n\nThe following relationships are true: \n- Courses have at least one Professor\n- Students can enroll in course\n- Courses have many Students\n- Students belong to many Campuses\n\n\n*NOTE:* You need to add Primary Keys and Foreign Keys to the tables, as well as add any joining needed. \n\n\n## Objectives\n- Practice working with SSMS and Databases\n- Understanding and creating a Database Diagram\n- Working with User Input and C#\n\n\n### Explorer Mode\n\n- [x] Create a Database Diagram that illustrates the relationships. This should be a picture in the root of your repository\n- [x] Create the Database. I want to see the Create Database script that includes all the tables and relationships\n\n- [x] Create a \"admin\" Console app that allows a user to : \n  - [x] Add Professors\n  - [x] Add Classes\n  - [x] View who is enrolled in a class\n  - [x] View all Classes, who is teaching them, and who is enrolled\n\n- [x] Create a \"student\" app that allows a user a to enroll into a class. \n  - [x] As a user, I should be able to select a course, and type in my information, and be enrolled in that course\n  - [x] Type in my name, and view what course I am enrolled in\n\n### Adventure Mode\n\n- [ ] Add Campuses to your data model as a \"Parent\" to all entities. Use your best judgement to define relationships\n- [ ] Update your data model to allow professors being apart of many campuses\n- [ ] Create a \"Professors\" console app that allows a professor to see who is enrolled in class\n- [ ] Add Semesters, and allow a student to select a semesters\n- [ ] Refactor your 2 console apps to be in the same solution, and re-use your database access layer \n\n\n### Epic Mode\n- [ ] Add Student sign in (*DO NOT STORE PASSWORDS AS PLAIN TEXT*)\n \n## Turning In\n\nYour homework will be assigned to you via `issues` on your `assignments` repository. Once you are\n\nThese steps will be followed for almost every assignment going forward. Once you've completed at` least _explorer_ mode and you're satisfied with your work, let's get it published. First let's get it up on GitHub.\n\n- First, let's add all our work to git, and ask it to commit it:\n\n  ```sh\n  git add .\n  git commit -m \"My first webpage\"\n  ```\n\n  Feel free to replace _\"My first webpage\"_ with a more meaningful message.\n\n- Push our local commits to GitHub:\n\n  ```sh\n  git push -u origin master\n  ```\n\nYour repository, for explorer mode,  should have three folders: \n- SQLScripts\n  - all your SQL scripts to create your database\n- AdminConsole\n  - the console app for the Admin app\n- StudentConsole\n  - the console app for the student app\n\n\n\n### Additional Code Samples: \nhttps://github.com/TIY-NET-Tampa/Lecture-Examples/tree/master/week-4/IntroToADONET/ConsoleApp1"},"comment":{"url":"https://api.github.com/repos/floh1695/assignments/issues/comments/384632280","html_url":"https://github.com/floh1695/assignments/issues/23#issuecomment-384632280","issue_url":"https://api.github.com/repos/floh1695/assignments/issues/23","id":384632280,"user":{"login":"mdewey","id":1793923,"avatar_url":"https://avatars2.githubusercontent.com/u/1793923?v=4","gravatar_id":"","url":"https://api.github.com/users/mdewey","html_url":"https://github.com/mdewey","followers_url":"https://api.github.com/users/mdewey/followers","following_url":"https://api.github.com/users/mdewey/following{/other_user}","gists_url":"https://api.github.com/users/mdewey/gists{/gist_id}","starred_url":"https://api.github.com/users/mdewey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdewey/subscriptions","organizations_url":"https://api.github.com/users/mdewey/orgs","repos_url":"https://api.github.com/users/mdewey/repos","events_url":"https://api.github.com/users/mdewey/events{/privacy}","received_events_url":"https://api.github.com/users/mdewey/received_events","type":"User","site_admin":false},"created_at":"2018-04-26T13:00:00Z","updated_at":"2018-04-26T13:00:00Z","author_association":"NONE","body":"![Awesome Work!](https://media1.giphy.com/media/3oKIPbZkQzX0abXd2U/200w_d.gif)"}}
{"actor":{"display_login":"mdewey"}}