access basic query Univ assignment...

[Susy]

hi there,



this is embarrassing, but I cannot do this task...

I created
1. the student table {StudentID, StudentName}
2. the course table {CourseID, CourseName, CourseStart, CourseEnd}
3. the studentcourse table {StudentID, CourseID, Grade}

I guess this is also wrong...

Can anyone help me here... I really don't know which is the best way to answer these two questions.

Cheers!

[jwhite]

Is this an pre-exam or class assignment?

[Bulzie]

You are close. But look at the Course dates, looks llke they could be different for the same course so do you have the dates in the right table?

[Susy]

jwhite... it is an old exam... actually.

[Susy]

Should the tblStudentCourseInfo have the dates or the tblCourse?

[jwhite]

To the point... Have you been given this as an assignment to complete for a grade? If so, you shouldn't be asking for answers; instead, use all available resources that help you solve the issue - not solve it for you.

[Susy]

Thanks jwhite for your concern. I already said that is an old exam. Thanks

[Bulzie]

If each course record is unique to a specific course and a course could have different dates, then dates cannot be in that table. So from what it looks like you are right, dates should be in the StudentCourse table.

[Susy]

Thanks, now I am trying to replicate the query from the exercises...

[orange]

Should the tblStudentCourseInfo have the dates or the tblCourse?

Think about these tables. And answer these questions in simple English, it will help you determine the answer to the question.

What exactly is a Course? (Think of the attributes of a Course as given in the original .csv file)

What does tblStudentCourseInfo represent? (Review junction table/linking table)

Good luck.

[Susy]

Almost getting there... some advice?

Attachment 28539Attachment 28540

[Susy]

Thanks orange... "answer the question in simple English..." hmmm

I am going to review the junction linking tables. Getting there :-)

[orange]

Susy,

You have made a design based on your assumption/understanding of the original data.
As Bulzie says IF.....,then . But there may be another solution(s) based on the original data and different assumption(s).

If you identify your assumptions, and treat these as business facts in your design, then I think you could have different solutions based on the assumptions/facts you make. When you make an assumption and design a database that supports those facts with the given data, you can defend/validate your design.

This may seem a little nit-picky (and it very well may be), but the original info "and any more to be added in the same format" could be interpreted as:

-more students, courses and grades , or
-more fields (teacher, room....times) all in .csv format

All this to say, write down/record your understanding -- as Bulzie did, then design to those facts.

Good luck.

[Susy]

Hi! This is all very instructive... I am learning alot... Thanks

[Susy]

hmm, still cannot answer question 4... really annoying.