Transcript Group projects

Connect to your SQL Server
 Log on an IST Windows machine
 If not in the lab, use remote desktop
 https://www.up.ist.psu.edu/vlabs/
 Or in your browser:
https://svg.up.ist.psu.edu/rdpdirect.html?gateway=svg.up.ist.psu.edu&server=vlabsweb.up.ist.psu.edu&mapClipboard=on
 Run the SQL Server application
 Start  Application Development and Management Microsoft SQL
Server 2014 SQL Server 2014 Management Studio
 Parameters




Server Type: Database Engine
Server Name: upsql
Authentication: Windows Authentication
Alternate Authentication (connect to the same database):
 SQL Server Authentication
 Get your SQL account: https://www.up.ist.psu.edu/db/mssql.php
 Hit “Connect”
 Navigate to your own database under the Databases folder
(IMPORTANT!!!)
 Your database name is your PSU ID
IST210
1
Group project
IST 210 Group assignments
Group 1 - 3
Group 1
•CHRZANOWSKI,
PIOTR
•GUERRA,
STEPHEN
•MERTZ, RYAN
•ROBERTS,
SAMUEL
•SABATINI,
CAMERON
Group 2
•FREETH,
NICHOLAS
•JACOBY,
SEANROBERT
•MYERS,
MATTHEW
•VOHRA, NEIL
Group 3
•ESTEVES, JOHN
•FANG, LE
•MCPHILLIPS,
DANIEL
•RADER,
BENJAMIN
Group 4 - 6
Group 4
• BEER,
RAYMOND
• DESTIN,
GEORGES
• SHANTZ,
STEPHEN
• TACCONI,
MARCO
Group 5
• KIM,
YOOKYUNG
• VIRADIYA,
ISHANI
• WEBER,
ALEXANDER
• ZIAB, NADA
Group 6
• KLETTER,
RICHARD
• LECKENBY,
RYAN
• STAFURSKY,
AUDRA
• WIMER, HOPE
Group 7-9
Group 7
• JOHNSON,
DARRIN
• NUSS, TYLER
• PATEL, DISHA
• PINTO, LUKE
Group 8
• BARBOUR,
FRANCIS
• GUAN,
ZHENZHONG
• RAPAPORT,
MARISSA
• SILVERWOOD,
CHRISTOPHER
Group 9
• BRILLIANT,
DAVID
• GODIN, HILARY
• PERLMAN,
ZACHARY
• SAMUEL,
JOSHUA
Groups 10 & 11
Group 10
Group 11
•BECERRA, NATALIE
•CIMINA, GARRETT
•HALL, EMILY
•POULIN, NICHOLAS
•YEN, HENRY
•BARRETT, SAMUEL
•COCHRAN, EMILY
•KIM, KANG SAN
•SCHARNITZ, BRIAN
•STONE, MATTHEW
Project – Report 1
IST 210 Organization of Data
IST210
7
Report 1 Project Proposal
 Project Title. Team Number. Team Members (name and id).
 Project Summary.
 It should be a short description of what your project is.
 Project Description.
 Plan of your team work:
 How often to meet?
 How to coordinate the team work? Lead rotation for each
stage?
IST210
8
Project description
 What kind of service is the project aimed at? Who are the
users/clients? Why your project is useful for your users? How is it
different from existing websites?
 What kind of data will be involved? How do you plan to collect
such data? How much data do you plan to collect?
 Description of the functions that you plan to offer. Think about
the functions from the users' point of view. How users are going
to use your system? All the functions need to interact with
database. You need to have at least 5 functions.
IST210
9
Database functions
A function should belong to one of the following categories
 Query database. e.g. browser job lists, search for a particular job
with some keyword
 Insert data into a database. e.g. add a new job, leave a comment
 Update data. e.g. modify a job description
 Delete data. e.g. delete a job
IST210
10
Requirements
 Answer all the questions above.
 The report must include a log on group activities (see the bottom of this
page for instruction). 30% of grades account for individual grade adjustment.
 Only one person in each team needs to make the submission in
ANGEL. Don't make duplicate submissions.





IST210
Project report 1 is due on Sept 23rd Wednesday 11:59PM
Get started today!
Browse past projects for inspirations!
https://www.youtube.com/channel/UCaag8UFP5B73NRSC5YhHZaQ
https://www.youtube.com/channel/UCLTMn5zyFv-AZ3-gxwj-OxA/videos
11