Database Quiz

I sat for this database quiz recently. And unfortunately i flunk it. 19/50 just because of conceptual error. Superkey is not a key and I lost 25 marks. WTF. Seriously. Only in NTU then it is not a key. Such a question can be so deadly. And not even one or two marks is awarded to me. Damm.... my life. A DBA aspired how can score that badly. Guess I have to work extremely hard now. But I realise one thing, I have learn how to cope with failures and move on. Something which I say I can't in the past. Will post all the lab answer and quiz after the semester to share with all other ppl. My aim this semester to break into second lower honour. Hopefully.

Life sucks in NTU

Well.... I would say life in NTU computer science is really not easy. But I have learn alot. Everyday, it's either juggling with coding or lectures or tutorials or CCAs because I need to stay in hall as I live too far away from Pulau NTU. I do not really have time for myself seriously. Wake up in the morning 6 am and reach home at 12 midnight and it starts all over again. Then Saturday and Sunday have to chiong projects and recorded lecture because you really cannot grasp what the professor are speaking. I would say half of them don't even know what they are teaching. Why do I say so? Well.... there are instances when we ask them questions, the prof or the lecturer would try to push by saying it's in the note or you have to google it yourself or blah blah. I know of one who would tell you something like this.... "you should have learn this in the lecture note...." or "Everything could be found in the notes". Dude if we have known the answer, we do not need to ask you in the first place and you do not need to be here. Seriously, knowing your work and educating others is really two different entities. Now, I really appreciate all my teachers back in primary all the way to JC days. So i guess this also further imply that you could be an elitist but that doesn't make you god. Sometime i do really wonder how does NTU choose their prof? Is it like how Iphone chose their staff (Grades) which makes them weaker ever since the fall of their god Steve Job. Do not forget it's the student who improve the ranking and not the professor. And mind you, the students from China, India, Vietnam are doing well because they learn it before in their homeland and not from NTU. This could be seen from their absenteeism from lectures. I once talk to some of the deans in my school, they told me theres no point going for lecture. Just do your work and prepare for the final because the final is the most important. Fuck care about the mid term and the rest coz it's wasting your time. Is that true? Can someone clarify with me?

Life in NTU Computer Science

Well.... I really hated my course. Computer science. If given a choice, I would have chosen something else. Something that is less project intensive. I think NTU Computer Science is the most intensive among the four Universities offering the IT courses. Not only are the project tough, where you would find yourself figuring how to solve the problem yourself with no lecture slides to go through but only Google as your best companion, the quiz question depending if you are lucky or not you may get question that test you on one single concept throughout the entire paper. Yeap, it's throughout. So for example, out of complacency or time constraint, you miss that one single chapter or page, "Boom" you fail. It's seriously not fair and I feel that it is not the best way to test a student especially when you just change your syllabus with limited amount of Pyp to refer to and with so many heavy project throughout the entire semester. There could be the reason why 50% of our cohort are hating what they are studying and thus pulling the grades down. I also feel it's super unfair as the foreigners may have done that in their own country and hence are not on even ground. How can you set a bell curve like that. That is not teaching le. That is call learn it yourself. No wonder many of us are not turning up for lecture because it is pointless. You are setting question from things that you are not teaching. Haiz... I really feel it that way. Hence I would persuade those who is coming into NTU Comp sci to think twice before coming. Do not regret or tricked by the salary survey. Life throughout the four years are tougher than you can imagine.

CZ 1007 Lab 2 Q1
#include stdio.h
int main()
{
float sum =0, item, count =0, average;
int num;
printf("Enter number of lines:\n ");
scanf("%d",&num);
for(int i =1; i<=num; i++)
{
printf("Enter line %d : \n", i);
scanf("%f", &item);
while(item != -1)
{
sum +=item;
scanf("%f", &item);
count ++;
}
average = sum/count;
printf("Average = %f \n", average);
}
return 0;
}

CZ1007 Soln To lab1

FS2 CZ 1007 LAB 1. Attached are my solutions to lab 1. *************************************************************************

Q1.
#include stdio .h
int main()
{
float celsiusTemp, fahrenheitTemp;
printf("Enter the temperature in degree F: ");
scanf("%f", &fahrenheitTemp);
celsiusTemp = (fahrenheitTemp - 32)*5/9;
printf("Converted degree in C: %f", celsiusTemp);
return 0; }

**************************************************************************

Q2.
#include stdio .h
#define _USE_MATH_DEFINES
#include math .h
main()
{
double radius, height, volume, surfaceArea;
printf("Enter the radius: ");
scanf("%lf", &radius);
printf("Enter the height: ");
scanf("%lf", &height);
volume = M_PI * radius * radius * height;
surfaceArea = 2*M_PI * radius * height + 2 * M_PI * radius * radius;
printf("The volume is: %f \n", volume);
printf("The surface area is: %f", surfaceArea);
return 0;
}

***************************************************************************

Q3.
#include stdio .h
int main()
{
float a1, b1, c1, a2, b2, c2, x, y, ans;
printf("Enter the values for a1, b1, c1, a2, b2, c2: ");
scanf("%f %f %f %f %f %f", &a1, &b1, &c1, &a2, &b2, &c2);
if (a1*b2-a2*b1 != 0)
{
x = (b2 * c1 - b1 * c2)/ (a1 * b2 - a2 * b1);
y = (a1 * c2 - a2 * c1)/ (a1 * b2 - a2 * b1);
printf("x = %f and y = %f", x, y);
}
else
{
printf("Invalid inputs");
}
return 0;
}

******************************************************************************

Q4.
#include stdio .h
#define _USE_MATH_DEFINES
#include math .h
int main()
{
float x1, y1, x2, y2, distance;
printf("Enter the first point x1 y1: ");
scanf("%f %f", &x1, &y1);
printf("Enter the second point x2 y2: ");
scanf("%f %f", &x2, &y2);
distance = sqrt((x1-x2) * (x1 - x2) + (y1 - y2) * (y1-y2));
printf("The distance is %f", distance);
return 0;
}

*****************************************************************************