Skip to content

the university registrar has requested an application that allows them to input students to courses and courses assigned to students. using many-to-many relationships written in c# utilizing vscode and mysql workbench.

Notifications You must be signed in to change notification settings

tmemmerson/UniversityRegistrar.Solution

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

49 Commits
 
 
 
 
 
 

Repository files navigation

University Registrar

"Register and fork over those dollas"

ABOUT

  • As registrar, I need to add name & enrollment date for students

  • As registrar, I need to add courses that the university offers

  • As registrar, I should be able to provide a course name & number

  • As a registrar, I want to be able to assign students to a course

  • Courses have many students & students take courses concurrently

✅REQUIREMENTS

💻SETUP

copy this url to clone this project to your local system:

https://github.com/tmemmerson/UniversityRegistrar.Solution.git

Once copied, select "Clone Repository" from within VSCode & paste the copied link as shown in the image below.

cloning


With the project open to the root directory, navigate to the production directory with the following command in your terminal.

cd ProjectName

Then, install the necessary packages with the following command

dotnet restore 

Finally, you can start the program with this command.

dotnet run 

cloning

Copy and paste this code snippet into the query field in MySql Workbench. Then execute w/ Control+Shift+Enter.

%%%EDIT%%% import

🔧PROTECTING YOUR DATA

Step 1: From within VSCode in the root project directory, we will create a .gitignore file

For l-top

touch .gitignore 

For l-top

ni .gitignore 

Step 2: commit that .gitignore file (this prevents your sensitive information from being shown to others). ⚠️DO NOT PROCEED UNTIL YOU DO!⚠️

setup

Step 3: To commit your .gitignore file enter the following commands

git add .gitignore
git commit -m "protect data"

Step 4: Then, you need to update your username and password in the appsettings.json file.

by default these are set to user:root and an empty password. if you are unsure, refer to the settings for your MySqlWorkbench.

appsettings


📫QUESTIONS AND CONCERNS

Questions, comments and concerns can be directed to the author Tristan Emmerson & Micheal Hansen


🔧Technologies Used

Written in: Visual Studio Code

Image work: Adobe Photoshop

Database Mgmt: MySql Workbench


🐛Known Bugs

None as of: 8/3/2020


❤️Contributors


Micheal Hansen


Tristan Emmerson


📘License

License: MIT

Copyright (c) 2020 Tristan Emmerson, Stickerslug Inc.

About

the university registrar has requested an application that allows them to input students to courses and courses assigned to students. using many-to-many relationships written in c# utilizing vscode and mysql workbench.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published