Skip to content

Latest commit

 

History

History
293 lines (217 loc) · 9.29 KB

README.md

File metadata and controls

293 lines (217 loc) · 9.29 KB
Raw

ProjectLogo

Individual_Project_PartB

💡Assignment to practise SQL fundamentals connected with C# and Entity Framework.

Description

Following PART A you need to implement the below functionality:

  • Design the ERD of your system and verify it through an online tool such as https://sqldbm.com/(it requires a free account) [15 marks]

  • Identify any other tables you need based on your implementation and construct them [15 marks]

  • Make the schema of a database that can keep data for the main entities of the assignment and name the tables as: Students, Trainers, Assignments, Courses [15 marks]

  • Populate the tables of the database with enough data [10 marks]

  • You need to produce sql queries that output the following [19marks in total]:

    • A list of all the students [2marks]

    • A list of all the trainers[2marks]

    • A list of all the assignments[2marks]

    • A list of all the courses[2marks]

    • All the students per course[2marks]

    • All the trainers per course[2marks]

    • All the assignments per course[2marks]

    • All the assignments per course per student[2marks]

    • A list of students that belong to more than one courses[3marks]

  • You also need to produce a small project that [26 marks]

    • makes a connection to the database and executes the above sql queries[9 marks]
    • makes a connection to the database and inserts inputdata from the keyboard to the following tables,
      • students[2 marks]
      • trainers[2 marks]
      • assignments[2 marks]
      • courses[2 marks]
      • students per course[3 marks]
      • trainers per course[3 marks]
      • assignments per student per course[3 marks]
You need to submit all the produced files in a zip file named by your_name_individual_partb.zip

📋Table of contents

📐SQL Schema

SQL SCHEMA

🧱Models

👨‍🎓Student

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

👨‍🏫Trainer

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

🧮Course

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

🏋️Assignment

Type Properties Methods Required
int AssignmentId get,set [x]
string Name get,set [x]
string Description get,set [x]
int Points get,set [x]
string DownloadLink get,set
bool IsSubmitted get,set
bool IsUploaded get,set
int? TrainerId get,set
int? CourseId get,set

🔝Back

🌁City

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

State

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

🈴Grade

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

🔝Back

Enum

Choice

Number Message
1 Students
2 Trainers
3 Courses
4 Assignments
5 StudentCourse
6 TrainerCourse
7 AssignmentCourse
8 AssgnmentsPerCoursePerStudent
9 StudentsInMultipleCourses

Difficulty

Number Message
1 Easy
2 Normal
3 Hard

Notification

Number Message
1 Start_Proces
2 Start_Application
3 Completed
4 Not_Working
5 Error
6 Please_wait
7 End_Process
8 Exiting_from_Application

Stream

Number Message
1 By_TEAMS
2 On_Demand
3 In_Class

🔝Back

Subject

Number Message
1 HTML_FUNDANMENTALS
2 CSS_FUNDENMENTALS
3 JS_FUNDENMENTALS
4 CSHARP_FUNDENMENTALS
5 SQL_FUNDENMENTALS

TypeCourse

Number Message
1 FULLTIME
2 PARTTIME
3 REMOTE
4 HYDRID
5 PRIVATE

👓Interfaces

  • ISimpleModel

  • IPerson

🔝Back

🐕‍🦺Services

MockupRepository

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

MyInsertDB

Type Properties Methods
int ID get, set
string FirstName get, set
string LastName get, set
double PhoneNumber get, set

🏵️Views

  • AssignmentView

  • CourceView

  • StudentView

  • TrainerView

🔝Back