Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Closed Thread
Can you help with this database assignment?
Old 09-19-2010, 02:12 PM Can you help with this database assignment?
Novice Talker

Posts: 7
Trades: 0
How do I delete this?

Last edited by hally; 09-20-2010 at 05:59 PM..
hally is offline
View Public Profile
 
 
Register now for full access!
Old 09-19-2010, 02:19 PM Re: Can you help with this database assignment?
Ultra Talker

Posts: 366
Name: Steve
Location: Miami, FL, Earth
Trades: 0
Cheating in school is only cheating yourself, because you train yourself to depend on others and suck at your job.

My suggestion is do it yourself or change your major to something you want to learn...
__________________
- Steve

President,
Please login or register to view this content. Registration is FREE
smoseley is offline
View Public Profile Visit smoseley's homepage!
 
Old 09-19-2010, 02:28 PM Re: Can you help with this database assignment?
Novice Talker

Posts: 7
Trades: 0
and this

Last edited by hally; 09-20-2010 at 06:01 PM..
hally is offline
View Public Profile
 
Old 09-19-2010, 02:39 PM Re: Can you help with this database assignment?
Novice Talker

Posts: 7
Trades: 0
I guess asking if you consider it cheating is a bit silly.
hally is offline
View Public Profile
 
Old 09-19-2010, 02:52 PM Re: Can you help with this database assignment?
Ultra Talker

Posts: 366
Name: Steve
Location: Miami, FL, Earth
Trades: 0
Well there's no way to answer your questions without doing your work for you. If you started with a schema and asked for one specific piece of help, it would seem less like asking someone to do the work for you.
__________________
- Steve

President,
Please login or register to view this content. Registration is FREE
smoseley is offline
View Public Profile Visit smoseley's homepage!
 
Old 09-19-2010, 05:32 PM Re: Can you help with this database assignment?
Novice Talker

Posts: 7
Trades: 0
this too

Last edited by hally; 09-20-2010 at 06:02 PM..
hally is offline
View Public Profile
 
Old 09-19-2010, 07:17 PM Re: Can you help with this database assignment?
Ultra Talker

Posts: 366
Name: Steve
Location: Miami, FL, Earth
Trades: 0
That's not a schema, that's a diagram.

A schema should look like this:

Code:
CREATE TABLE student (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL INDEX,
    etc,
    etc
);
One thing I notice in your diagram is that none of your tables have auto-numbering identity columns... didn't you learn this in school?

A relational database should work as follows:

  1. Always use lower_case_underscore naming conventions for databases... this is the universally supported standard between all databases (some don't support upper-case, some don't support spaces, etc.).
  2. For 3rd normal form, every data type that has a repeatable value should be contained in a unique table. For example, in your design, there should be a table called Semester, with the values 1-Fall, 2-Spring, 3-Summer. That table should then be referenced by semester_id
  3. Each table has a unique ID (preferably an auto-incremented number - every database has the ability to handle this)
  4. Relationships are handled as a numeric ID referencing the parent table..., for example the "course" in table "section" should be course_id INT NOT NULL REFERENCES course(id).
  5. Composite Keys, such as Grade Report, should be a combination of two foreign key relationships to form a unique id, e.g. student_id INT NOT NULL REFERENCES student(id), section_id INT NOT NULL REFERENCES section(id), PRIMARY KEY(student_id, section_id)
__________________
- Steve

President,
Please login or register to view this content. Registration is FREE

Last edited by smoseley; 09-19-2010 at 07:26 PM..
smoseley is offline
View Public Profile Visit smoseley's homepage!
 
Closed Thread     « Reply to Can you help with this database assignment?
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.18261 seconds with 12 queries