Schools DB Confusing Problem

Oct 6, 2007

I am trying to redesign an older DB for a school,
to meet the new needs that emerged.
I am totally confused due to the complexity of the problem. I've already searched in this forum and in Google but most articles are for simpler DBs.
Well to get to the point.

School has Students,
Students attend to Classes (many to many)
Students are assigned Lessons (many to many)
and coming to the confusing part
a Lesson in specific Class may be teached from two different Professors
(e.g. the 1st may teach the theory and the other the excersizes).
So another many to many Class-Professor and another Class-Professor-Lesson and so on?

After throwing away many sheets of paper I come up with a schema which seems a little bit strange but seems to going to work for my case.
I figure out that I could have a unique junction table storing all these info, and that's no other than the Schedule table.
So I'm thinking of having the following relationship schema:

Students
StundeID
Name
etc.

Lessons
LessonID
Title

Classes
ClassID
Title

Professors
ProfessorID
Name
etc.

Schedule
ScheduleID (maybe a combination of all others)
ProfessorID,join with Ptofessors
ClassID, join with Classes
LessonID, join with Lessons
Day
Time

Schedule_Students
tableID
ScheduleID,join with Schedule
StudentID, join with Students


What is your oppinion about? Can you see any problems which may emerge from such a design?
Thanks in advance

View Replies


ADVERTISEMENT

Confusing

May 12, 2005

Ok this may seem very confusing as alot of things need to happen for what I am trying to do

I am doing an inventory database that contains all order, client, purchasing, and inventory information.

I have a table that has all of the different products we sell (also includes which of the following tables are needed) I also have separate usage tables storing how many of each part (given a partnumber) for each of the products.

Now this is where the complecation comes in .When I create an order I want to 1. add a record to my order table (containing ordernumber, client number, product purchased) 2. using the product table, find out which usuage tables need to be looked at, go into those usage tables, get the number of each part that is needed for the product and store the value into an allocation table

I have had this on my mind for the past 2 weeks that I have know I will have to do this at some point. I am getting to the point where I cannot do anything else without this being done. I need help something bad.

If you feel you know how to do this and think you need more information, email me at cgow1@cogeco.ca

View 1 Replies View Related

ER-D Really Confusing! Please Help!

May 1, 2007

Hello, Im creating a database for a charity just to get some experience and im stuck on something - my table structure.

I know you might find it a bit difficult because you dont know the background info but i need the database to be able to let customers and members make bookings. Ive thought of putting both customers and members in one table but i dont want it to get complicated and messy, although i will do that if there is no other way.

The ER-D is attached.
17309

Is there a solution to my dilemma?
Ant...

View 2 Replies View Related

Confusing Use Of Validation

Feb 7, 2005

Hi everyone,
basically what i need to able to do is set a validation rule that allows me to enter a value that is between 5 and 10 kgs but (and here comes the confusin bit is also rounded to the nearest 5kg. I tired using the[ like "?.?0" or "?.?5" ] command but have so far been unsucessful. Also i really like oranges.

View 5 Replies View Related

Very Confusing & HUGE Challenege..need Help.

Nov 8, 2005

One of our key customers (GE) has demanded that we begin to submit our estimates in their transmission 160 character format.

Basically it it a txt file that looks like this all on one line.
1ABCDWXYZ0502EST TEST123456T050208654321C 00010851803098518031 000000E 0000000000000D CAR SHOPPED AS CLEAN-PROCEED WITH

Only a couple of those characters are in my database and will change. Other than that items will continously be the same. The items that are optional and we don't have not only have to be blank but have to have spaces there instead...not 0's.

How do I set up a query to kick all of this out? I tried something like:

GEString:2UPRR YYMM00&""&WorkOrderID yada, yada, yada

but it didn't work....any ideas? I also need the YYMM to be the current year/month and I have to pull the decimals out of the estimated billing costs.

Is there a better way to do this? As you can imagine...typing 5+ pages of this for each job would be a NIGHTMARE!

View 13 Replies View Related

Confusing Query-type Help

Aug 11, 2005

This is a bit confusing, so I'll try to explain it well.

Two tables. One has a list of metals. The other has a list of submetals, and what basic type of metal it is. It's grabbing the second column from the first table. Makes sense, right?

Now, I have another table, with links to both of those fields. What I want it to do is when it picks the metal type, to filter the subgroup to only the types it has associated with it to the basic metal type. Not sure if that makes sense. I'll supply an example.

Table 1
Aluminum
Brass
Copper

Table 2
Subgroup Basic group
License Plate Aluminum
Iron Aluminum Aluminum
Yellow Brass Brass
Copper Wire Copper

Now, if in Table 3, they choose Aluminum from the drop down box for basic metal, I want the dropdown box for the subgroup to have only License plate, and Iron Aluminum. For Brass, only Yellow Brass, and the same for copper.

Any ideas on how to implement this?

View 3 Replies View Related

Query Results From Iif Statment Confusing

Jun 1, 2006

I've got an unbound form which has a field that I need to relate to from a query, I've got no problems relating to specific records, but I've not quite cracked the ability to select all other records if the field is left at 0.

I've tried using in the query under the 'table' field (for selecting a specific group of people seated at a particular table)

Iif([Forms]![TablePlannerFrm]![TableSel]=0,>0,[Forms]![TablePlannerFrm]![TableSel])

Which I thought would evaluate a true/false with the two results coming from the two options, so if the Table selected on the unbound form was set to 0 then it would set the criteria to >0 (everything table 1 and up), or if anything else was selected other than 0, it would use the number from the unbound form from the TableSel field.

I'm getting blank results from both positive and negative results. I assume that I'm not using the Iif statement correctly, or that there is another way of approaching the problem that my headache is blocking :)

Thanks everyone

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved