class policies - Personal Web Pages

Download Report

Transcript class policies - Personal Web Pages

Database Design and Implementation
ITCS6160 & ITCS 8160
Instructor: Jianping Fan
Time: Thursday 9:30AM-12:15PM
Classroom: Woodward Hall 130
Course Webpage:
http://www.cs.uncc.edu/~jfan/itcs6160.html
Why you should take this course





Good job market (at least now)
Easy to learn (database ``is not” science)
Have fun (if you enjoy learning &
programming)
Required by MS degree for Data Science
Database (Data Science) is the
foundation of computer science!
Early-Evaluation Policy




If you get BS degree from CCI at UNCCharlotte
You have taken undergraduate class: ITCS3160
under me not others!
You can request early-evaluation: pass some
pre-tests (same requirements like other
students in this class)
You pass the tests and get my permission
Early-Evaluation Policy
If you are really good, you are
allowed to just come for mid,
final tests and deliver project only!
If you fail anyone of these conditions, you have to come every week!
Talk to me after class! Just today!
Class Policy





Come early (no late than 9:30AM), do not
leave classroom within my lecture!
Do not bring food into classroom, especially do
not eat in the class (F grade may be given)
Do not talk in the class, but welcome to ask
questions!
Share your ideas in the class & Interaction with
instructor
Help on distributing information
Text Book



Raghu Ramakrishnan, Johannes Gehrke,
``Database Management Systems”,
Mc-Gram Hill, third edition
Why this book?
TA: Tianyi Zhao, Woodward Hall 202,
[email protected]
1. Topics








E-R model
Relational model
SQL
Database implementation
Database indexing: B-tree & Others
Transaction management
Query plan & optimization
Advanced database
2. Grade Format






5% for show-up in the class
15% for home-works (7 totally)
30% for mid test
40% for final test
10%-15% for project implementation
Bonus will be given to good project
implementation!
3. show-up & in-class rules



You have to attend class except….
If you cannot attend the class, you
should let instructor know one day
before by email or phone-call.
Hands-on learning classes
If you miss 3 or more classes without good reasons, you are not allowed to take
mid-term and final tests!
3. show-up & in-class rules



You are not allowed to leave for restroom (we
have break time) or answer phone-call within
my lecture.
Do not bring foods into classroom, you are not
allowed to eat in my lecture time. If you are
so hungry, you may not come to class. You
should be hungry on learning new knowledge
rather than food!
others
4. Homework



We will assign 7 homework
You will get benefit from these homework
15% if you turn in all of them
Mid-test or final test questions will follow
the same format for homework
5. Mid-test: 3/16/2017



Mid test will cover E-R model, relational
model, relational algebra, SQL
If you get A in mid test, you will get 30%
benefit for your final grade
If you get B in your mid test and you want
to get A for final grade, you should get A
from both final test and project
6. Final Test: 5/11/2017



Final test will cover all the topics
which are presented in the class.
If you get A in final test, you can get
40% benefit
We will exactly follow our grade format
to give final grades!
7. Project


You are required to build a small
database system: data collection, schema
design, E-R model design, query interface, &
query optimization (if possible)
We do not encourage group project! If you
want, more requirements on group project
will be assigned.
8. Hands-on Learning




We will organize only one time hands-on
learning in computer lab, but you can
always educate yourself and spend more
time on implementing the course project.
We will focus on Oracle 8i
TA will do this hands-on learning
We will find our computer lab soon and let
you know immediately!
9. The way to improve yourself



Do your best for homework, mid and final
test and course project
You are welcome to send your feedback to
the instructor for improving the learning
environment for this class.
You can also make appointment to visit the
instructor or TA.
10. Suggestions from Instructor





Do your best in the class
Show your problems to the instructor or TA
when you cannot make it
Show the evidence to us if you think you are
right.
Open discussion is needed
You can definitely make this class better!
10-Hours-a-Week




2 hours for preparation before you
come to classroom;
3 hours for review & homework after
you leave the classroom;
2 hours for course project! Three
weeks late
3 hours for instructor lecture
I am a nice professor

If you do your best & follow class policy

If not, ……
Information will updated frequently!
http://www.cs.uncc.edu/~jfan/itcs6160.html
Push your professor to think deeper!
Do your best & have fun!
You can withdraw if you cannot accept the class policy!