---

---

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

• Models
  • Enum
    • Choice
    • Difficulty
    • Notification
    • Stream
    • Subject
    • Typecourse
  • Assignment
  • City
  • Course
  • Grade
  • State
  • Student
  • Trainer
• Interfaces
  • ISimpleModel
  • IPerson
• Services
  • MockupRepository
  • MyInsertDB

---

📐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