add a databasecomponent
All data should be stored in only one table of a relational DB (see textbook Chapter 11)
You can use Access DB (.accdb file) or other DB engine of your choice (I will be only able to help you with .accdb)
Each student will have his/her own domain field information
Choose what you will collect (preferably real) information about (background class for a table of data):
You can choose a line of products, series of events (like sport, cultural, or natural events, like weather records, volcano eruptions, etc), list of employees or students, courses, geographical objects, etc.
Main class of objects should have at least 7 fields (columns in the table)
ID (primary key)
2 text fields (name, category)
1 boolean field (Yes/No)
2 numeric fields (e.g. price, quantity)
1 date filed
you should have at least 30 records (objects/instances of main class)
You can use LINQ (queries written directly in C#) for search/data manipulation
Extend the functionality of Project 2 to allow for queries according to several different selection (filtering) criteria.
Use multiple forms.
Design your application as a business (your own, or the one you work for), such as a retail, rental store, service provider, agency, etc.:
Be creative and original, and most important:
Have Fun!
Follow Grading Rubric (below) as a ToDo checklist
Project 3 Grading Rubric
Max Points
Requirements / comments
UI Design + Objects naming
5
Clean and functional GUI design,
Rename all controls, DataGridView
Multiple Forms
3
Create at least 3 forms that will communicate
data between each other (see my video)
Input Validation
4
Use of tryParse | try..catch | domain check |
Focus on the control after finding error
Working with Data Base
6
Create Class and link it to your DB
Queries
8
At least 3 queries filtering your table
Search
3
Can be implemented as query(ies) or
by direct search over data table in a loop
Data Manipulation
5
Averages and other Data Analytics
Save Data
2
use Update() method
Remove Selected record(s)
2
+1 extra point for multiple selection
Documentation
7
Header with Program purpose/specifications (2),
Source code with comments (3),
Run-time screenshots with comments (2),
Solution Presentation
5
Demonstrate / explain solution and code in Discussion
Extra Features
bonus
(+)
Other Errors
deductions
(-)
Total
50(+)
(+) May exceed if extra features implemented
The post add a databasecomponent All data should be stored in only one table appeared first on PapersSpot.
