Initial Planning - Sprint 0

[Kayrim]

Everyones inputs below

[philanderson888]

User groups 1) Guest with restricted access (ie no GDPR data) 2) Client (Read only) 3) Consultant => Edit own CV 4) Staff => admin access

Would need a login for this.

[philanderson888]

CV display is main focus of app

[philanderson888]

Website with main NAVBAR headings

Home, Consultants, Courses, Trainers, About

Consultants => Show running courses => Click to individual students

Consultants page will show

 CV
Video CV
Projects pop-up

[Kayrim]

As a Client, I want to be able to see the technologies and languages used in their projects, so that I know what technologies and languages they can use.

[Kayrim]

[philanderson888]

Clarification of main goal of the app

Database to hold?

Students name, courseID, Bio, Projects, CV

CV can link to the OneDrive link of that person's CV anyway.

[philanderson888]

Must make sure correct access is given to the teams links so that the link would have to be read-only for non-owner of the CV

[philanderson888]

Solution - download the CV (this does the Read-only part) and have a separate link to the OneDrive editable CV

[Kayrim]

To get the CV get your share one drive file link

https://testingcircle-my.sharepoint.com/:w:/g/personal/kbakkali_spartaglobal_com/Eb8Pp-S-ErhOld1i2uVYxTYB4E2e9_8JrvWAYGa74j2OQw?e=Q2wg4J9

then add this to the end &download=1

[philanderson888]

Great work!

[Kayrim]

https://www.lucidchart.com/invitations/accept/6fbd5b63-abf8-4bc9-876f-e53d72e5e660

Example DB-Diagram

[philanderson888]

Cool, can log in with Google

[Kayrim]

use master 

go

drop database if exists SpartaDB

go

create database SpartaDB

go

use SpartaDB

go

CREATE TABLE Category (
    CategoryID int not null primary key identity,
    CategoryName varchar (100)
);

go

CREATE TABLE Trainer (
    TrainerID int not null primary key identity,
    LastName varchar(30),
    FirstName varchar(30),
    Photo varchar(255),
    Bio varchar (255)
);

go

CREATE TABLE Course (
    CourseID int not null primary key identity,
    CourseName varchar(30),
    CatgeoryID int foreign key references Category(CategoryID),
    LengthOfCourse varchar (100),
    CourseDescription varchar (255)
);

go

CREATE TABLE Consultant (
    ConsultantID int not null primary key identity,
    LastName varchar(30),
    FirstName varchar(30),
    CourseID int foreign key references Course(CourseID),
    Photo varchar(255),
    Bio varchar (255),
    University varchar (100),
    CvLink  varchar (255),
    VideoLink varchar (255)
);

go 

CREATE TABLE Project (
    ProjectID int not null primary key identity,
    ProjectName varchar(50),
    ConsultantID int foreign key references Consultant(ConsultantID),
    ProjectDescription varchar (255)
);

go

CREATE TABLE TrainerCourses (

    TrainerID int foreign key references Trainer(TrainerID) NOT NULL,
    CourseID int foreign key references Course(CourseID) NOT NULL,
    Primary Key (CourseID, TrainerID)

);

go

INSERT INTO Category Values
('Developer'),
('Business');

go

INSERT INTO Trainer (FirstName,LastName,Bio) Values
('Phil', 'Anderson' ,'I love Ketchup'),
('Markson', 'Jackson', 'okay'),
('Jim', 'Bob', 'Huh?');

go

INSERT INTO Course (CourseName,CatgeoryID,LengthOfCourse,CourseDescription) Values
('C# Dev',1, '10 Weeks', 'C# Development courses for learning programming full stack'),
('Java Dev',1, '10 Weeks', 'Java Development courses for learning programming full stack'),
('Business Analyst',2, '5 Weeks', 'Agile and some SQL');

go

INSERT INTO Consultant (FirstName, LastName, CourseID, Bio,University, CvLink) Values 
('Karim','Bakkali',1, 'I like food', 'Kings College','https://testingcircle-my.sharepoint.com/:w:/g/personal/kbakkali_spartaglobal_com/ESygUVXtrkJDp_ASoEt8-5sB-LcE9vxRs4R2t7qabrgi1g?e=ciSzl5'),
('Stephen','Callum',1,  'I want waves', 'Swansea University', 'https://testingcircle-my.sharepoint.com/:w:/g/personal/scallum_spartaglobal_com/Ebb2HBX3SVFPoqiek-NLFn8BCRxWWjCKwMxTx4clwFVMEg?e=A5RK35'),
('Jamie','Benjamin',1,  'I play games with my hands', 'Anglia Ruskin University', 'https://testingcircle-my.sharepoint.com/:w:/g/personal/jbenjamin_spartaglobal_com/EdjvHkjZPYZNlsDWaS-B7VsBuHixUolHMQ9Iy9Bum_Njow?e=Zw27W8'),
('Hassan','Abdullahi',1, 'I pray 5 times a day', 'Queen Mary', 'https://testingcircle-my.sharepoint.com/:w:/g/personal/habdullahi_spartaglobal_com/EV03xyraEEJEqZSjR8i7tvsB4mTf6b4tHpeQSW-AtBnFSA?e=0oDfRD'),
('James','Kavanagh',1,  'I like Jamie', 'University of Kent', 'https://testingcircle-my.sharepoint.com/:w:/g/personal/jkavanagh_spartaglobal_com/Ed86jNVYWjNAksXCVxg-DS4B7NgvGS0BMO0b7E869t4_bw?e=FOXl8T'),
('Timothy','Wong',1,  'Ooooo I like that', 'Brunel University', 'https://testingcircle-my.sharepoint.com/:w:/g/personal/twong_spartaglobal_com/EU4rd5GeALRHjfjvD9Gms8UBJPjRtoZSQqCQ8RWm5U4zDA?e=cbwxYC'),
('Jordan','Benbelaid',1, 'I left it on my home computer', 'Brunel University', 'https://testingcircle-my.sharepoint.com/:w:/g/personal/jbenbelaid_spartaglobal_com/EUkyclpdmxhBnY5yLkqFWwgBO_mhj_nWJdve1OFC7j9beA?e=WQAND3');

go

INSERT INTO Project (ConsultantID,ProjectName,ProjectDescription) Values
(1, 'Unity Game Project', 'Made a first person Shooter'),
(2, 'Unity Game Project', 'Made a third person platformer'),
(3, 'Unity Game Project', 'Made a flight simulator in space');

go

INSERT INTO TrainerCourses  Values
(1,1),
(1,2),
(2,2),
(2,3),
(3,1),
(3,3);