helloo People of PHPFREAKS!

[ojuniour]

this is my first time joining this forum , it was recommended by my good friend..

he told me that i should come here if i need help with mysql coding and here I am , and i hope we go along swiftly.

Thank you,

 

My problem is this:

 

Designing a small database with at least three entities and three relationships.

Your design may be a sales database, a personal collection database, a store database, or anything else which you think of.

 

Draw an E-R diagram for your database.

Draw a diagram of all of the functional dependencies in your database.

Check that your design is in 3NF.

 

State explicitly which is the primary key for each table

At least one table must have a multi-attribute primary key.

State explicitly which are the foreign keys for each table and what their primary key targets are.

 

Create your database on your computer using MySQL.

Make up sufficient data so that you can test your database.

 

Write and run at least three SQL queries to your database.

Use as many of the features of SQL which you learned this term as you can.

Your queries must join several tables or use subqueries.

 

Now  I know this might be a quite of challenge to you guys but if you can help me to some extend I will really aprreciate it

Also i am willing to pay $50 (US Dollar) to who can help me out with the problem, thank you.

 

and if you have any question you can contact me at valentinedpg@gmail.com, thank you

 

[Mchl]

Ok, so you obviously have a homework to do.

Now the question is, do you want to do it by yourself, or do you expect someone to do it for you?

If the latter, please head towards freelancing section. If former, show us what you got so far.

[ojuniour]

to be honest , it is more than a homework...

we have to make up things , and design it...everyone got a different choice

 

What i mostly need is a tutorial on how to begin and  a solid layout to begin with..

 

I will show you what I have so far...so it won't be like I am being lazy..i just need some direction , thats all..

[Jumpy09]

May have to post it, some people only help through the forums.

 

If you read my message before I edited it, I didn't read your second message.

[ojuniour]

Ok here I have posted the Entity Diagram

 

 

I will post the Functional dependency soon (using the 3NF diagram)

and from there On , If you guys can give me more directions

[ojuniour]

Ok umm i am starting to get confused with creating functional dependencies using 3NF

How do I derive one?

 

I know , I am a total noob at this 

[ojuniour]

can anybody help me with the functinal dependcy  (in 3nf) , please?

thats all I want

[Mchl]

Let's take your Patient, Doctor and Ward entities. Each of them would need separate table with primary key

 

table patients

----------------------

patientID, name, surname, SSN, gender, DOB, ...

 

table doctors

---------------------

doctorID, name, surname, specialisation ...

 

table wards

----------------------------

wardID, name, floor, ....

 

That's something for you to start with

[ojuniour]

thanks MCHL , i have made some progress so far and here are the few changes I have:

 

This is the new image and thsoe underlined are the primary keys for each table, and also since the question also says that at least ONE table should have have multiple-attribute keys ...... so I underlined two of  those primary keys over there:

 

now all I need is how to generate the 3nf diagram..

and then create the database

 

Please...My money offer still stan if you are reluntact to help me

I am also helping myself too 

[ojuniour]

and also Mchl, if you have like yahoo messenger, aim, skype, msn, facebook, or any live chat program ..that  I can use to contact you so I can be one with this quickly before Monday afternoon..

 

I know I might be asking much , but i wish there are other things I can do to speed up response..I have been refreshing this page since yesterday looking for a reply..

Please I need you sir.

 

or anyone who has experience to help me,

[Mchl]

Don't count on me then. I'm not here for money, and I will help only as much as my time permits.

 

I think you should drop your Assistant entity, as it is only complicating things, and it doesn't seem to be fulfilling any requirements in your assignment.

 

Anyway, you should stop drawing diagrams now and create some tables.

[ojuniour]

ok thank you...

But i still don't have any idea on how to start the 3nf diagram for the functional dependecy

 

Or do I have to create the table first before doing that?

[Mchl]

It's hard to help you without knowing what your course did cover. For me the diagram above would be sufficient to start creating tables. I gave you starting examples above, but they're missing foreign keys (I've left them out so that you can think on how to implement them  )

[ojuniour]

I just need some example on how to create the 3nf diagram based off the entity diagram , that's all, if you can just show me one example and/or explanation  then the rest will be pretty much spot on. 

 

Please

 

by the way...I have created whole tables and removed the health assistant.

 

if you want me to post the table(s) I created.....tell me

[Mchl]

The problem is, I don't really know what '3nf diagram' is supposed to be. I know what normal forms are (3rd and further inluded), but a diagram? No idea?

[ojuniour]

oh....ok

 

if there is nothing like '3nf diagram' then why would he say that we should draw one

 

so what will the functinal dependencies' be then? :-\

[ojuniour]

it really sucks man , got a helpful reply and then ....it's not soo....idk