You are tasked with making a database diagram, database, and 2 console applications
The database will have at least the following entities, and the following columns:
Courses
Number
Level
Name
Room
Start Time
Professors
Name
Title (Mr/Ms/Dr, etc...)
Students
FullName
Email
PhoneNumber
Major
The following relationships are true:
Courses have at least one Professor
Students can enroll in course
Courses have many Students
Students belong to many Campuses
NOTE: You need to add Primary Keys and Foreign Keys to the tables, as well as add any joining needed.
Objectives
Practice working with SSMS and Databases
Understanding and creating a Database Diagram
Working with User Input and C#
Explorer Mode
[x] Create a Database Diagram that illustrates the relationships. This should be a picture in the root of your repository
[x] Create the Database. I want to see the Create Database script that includes all the tables and relationships
[x] Create a "admin" Console app that allows a user to :
[x] Add Professors
[x] Add Classes
[x] View who is enrolled in a class
[x] View all Classes, who is teaching them, and who is enrolled
[x] Create a "student" app that allows a user a to enroll into a class.
[x] As a user, I should be able to select a course, and type in my information, and be enrolled in that course
[x] Type in my name, and view what course I am enrolled in
Adventure Mode
[ ] Add Campuses to your data model as a "Parent" to all entities. Use your best judgement to define relationships
[ ] Update your data model to allow professors being apart of many campuses
[ ] Create a "Professors" console app that allows a professor to see who is enrolled in class
[ ] Add Semesters, and allow a student to select a semesters
[ ] Refactor your 2 console apps to be in the same solution, and re-use your database access layer
Epic Mode
[ ] Add Student sign in (DO NOT STORE PASSWORDS AS PLAIN TEXT)
Turning In
Your homework will be assigned to you via issues on your assignments repository. Once you are
These 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.
First, let's add all our work to git, and ask it to commit it:
git add .
git commit -m "My first webpage"
Feel free to replace "My first webpage" with a more meaningful message.
Push our local commits to GitHub:
git push -u origin master
Your repository, for explorer mode, should have three folders:
University of PROforma
You are tasked with making a database diagram, database, and 2 console applications
The database will have at least the following entities, and the following columns:
Courses
Professors
Students
The following relationships are true:
NOTE: You need to add Primary Keys and Foreign Keys to the tables, as well as add any joining needed.
Objectives
Explorer Mode
[x] Create a Database Diagram that illustrates the relationships. This should be a picture in the root of your repository
[x] Create the Database. I want to see the Create Database script that includes all the tables and relationships
[x] Create a "admin" Console app that allows a user to :
[x] Create a "student" app that allows a user a to enroll into a class.
Adventure Mode
Epic Mode
Turning In
Your homework will be assigned to you via
issues
on yourassignments
repository. Once you areThese 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.
First, let's add all our work to git, and ask it to commit it:
Feel free to replace "My first webpage" with a more meaningful message.
Push our local commits to GitHub:
Your repository, for explorer mode, should have three folders:
Additional Code Samples:
https://github.com/TIY-NET-Tampa/Lecture-Examples/tree/master/week-4/IntroToADONET/ConsoleApp1