ojuniour Posted May 13, 2010 Share Posted May 13, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/ Share on other sites More sharing options...
Mchl Posted May 13, 2010 Share Posted May 13, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1057598 Share on other sites More sharing options...
ojuniour Posted May 13, 2010 Author Share Posted May 13, 2010 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.. Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1057606 Share on other sites More sharing options...
Jumpy09 Posted May 13, 2010 Share Posted May 13, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1057609 Share on other sites More sharing options...
ojuniour Posted May 13, 2010 Author Share Posted May 13, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058016 Share on other sites More sharing options...
ojuniour Posted May 13, 2010 Author Share Posted May 13, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058023 Share on other sites More sharing options...
ojuniour Posted May 14, 2010 Author Share Posted May 14, 2010 can anybody help me with the functinal dependcy (in 3nf) , please? thats all I want Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058406 Share on other sites More sharing options...
Mchl Posted May 14, 2010 Share Posted May 14, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058428 Share on other sites More sharing options...
ojuniour Posted May 14, 2010 Author Share Posted May 14, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058530 Share on other sites More sharing options...
ojuniour Posted May 14, 2010 Author Share Posted May 14, 2010 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, Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058536 Share on other sites More sharing options...
Mchl Posted May 14, 2010 Share Posted May 14, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058546 Share on other sites More sharing options...
ojuniour Posted May 14, 2010 Author Share Posted May 14, 2010 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? Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058557 Share on other sites More sharing options...
Mchl Posted May 15, 2010 Share Posted May 15, 2010 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 ) Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058638 Share on other sites More sharing options...
ojuniour Posted May 15, 2010 Author Share Posted May 15, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058644 Share on other sites More sharing options...
Mchl Posted May 15, 2010 Share Posted May 15, 2010 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? Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058658 Share on other sites More sharing options...
ojuniour Posted May 15, 2010 Author Share Posted May 15, 2010 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? :-\ Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1058867 Share on other sites More sharing options...
ojuniour Posted May 16, 2010 Author Share Posted May 16, 2010 it really sucks man , got a helpful reply and then ....it's not soo....idk Quote Link to comment https://forums.phpfreaks.com/topic/201585-helloo-people-of-phpfreaks/#findComment-1059175 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.