July 5, 2008 at 1:59 pm
Hi there people ,i am new to this forum and new to SQL also.
Recently i have been given an assignment from my university to create a database from a discourse , i have carried out the work but really haven't got much knowledge and would like to have some feedback from you guys if you can help me.
I have the assignment , and my completed work ready for email if any of you can take time out to help me out on this.
Thanks a lot ,San. 🙂
July 5, 2008 at 4:43 pm
Any reason you cannot just post it here as an attachment?
That way we can see what this is before we make a commitment to you.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 5, 2008 at 5:51 pm
Hello there , Ive uploaded the assignment and my work on it so far , your help would be much appreciated , i just need to know if i am doing it right and heading in the right direction.
I am forever grateful for your time , Thanks again , San
July 5, 2008 at 7:54 pm
The first sentence of the 3rd page of your assignment sheet says:
The following should be an individual piece of work.
Before we go any further, I strongly recommend that you contact your instructor and confirm whether or not you are allowed to ask for or receieve our help on this. If you are please find out and tell us very specifically what kind of questions and help you may ask for and what kind of answers and help we may give without endangering your grade or your status as a student.
I ask this because in the past year there have been a number of students here in the U.S. who have recevied failing grades for doing nothing more than what you are doing right now and in some cases they were even expelled from their schools. Now every school is different and this may be perfectly fine at your schoool, however, obviously, I would not want you to be penalized just because I was trying to help you.
And since this is an open forum, anyone, including your classmates or even your instructor could be reading this right now.
Also, I would hope that no one else would start to answer your original request until you had checked on this.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 5, 2008 at 8:43 pm
Many of the suggestions that we would recommend may not have even been covered by your instructor yet. I'm sure you have been given all the information you need in the lessons and in the textbook. You have already done the work, just double check and do the best you can. If you do not get a perfect score that is fine. Some of the things that I remember most are the things that I did not get right the first time.
July 6, 2008 at 6:33 am
Thanks guys , i understand exactly where your coming from.
Its not a sob story or anything , but because i had a lot of work on top of me i handed in the actual assignment 1 day late resulting in it not even been marked , i have been given a brand new assignment to carry out , but because i received no feedback from the original assignment which is uploaded on here then i don't know if im going wrong , i am not looking for specific answers more a guidance to say that im on the right tracks.
Thanks again guys , San.
July 6, 2008 at 11:13 am
Without being to specific then, I think that you need to review this design and rethink some parts of it.
In a typical design, you should have one or more tables at the "top". That is, other tables point to them, but they do not point to any other tables. You do not have any tables like this, which is probably a sign that something is wrong with your design.
Likewise, you should normally have one or more tables that are at the "bottom". Which means that they depend on (or "point to") other tables, but there are no other tables that depend on or point to them. These are you most basic "facts" and they often have the most rows. You also do not have any tables like this, which is also probably a sign that something is wrong with your design.
Generally, realtional table diagrams would not have any "cycles" of dependency. This cna validly happen sometimes, but it is rare and so cycles can also be take as a sign that something is wrong with the design. Even more so, 2 tables are not normally "co-dependent", that is, pointing to each other. This also can validly happen, but it should be reviewed closely to see if it is really correct. Your design has multiple cycles and co-dependency's.
Finally, you should think about what additional tables beyond those directly required might be needed to implement a valid design. In particular, many-to-many relationships cannot be correctly inplemented in relational databases with only 2 tables. This is because SQL relations can only directly represent (1 to 1) and (1 to many) relationships. To represent a (many to many) relationship between two tables you need a third table that both of the original tables have a (1 to many) relationship with.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 6, 2008 at 3:03 pm
There is a lot i don't understand about that , but that is why i am going to research it further , the assignment i have uploaded is not going to be the piece of work that is going to be marked , but i am going to apply my knowledge to the new assignment , this is why i needed feedback just to know if im heading in the right direction and am going to at least get 40% which is classed as the pass mark of this class.
i cant thank you enough for the time you have taken to have a look over this , Thanks , San
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply