Help with simple database
-
Hi guys, just wanted to ask if anyone can help me determine whether a table should be: 1. Left in its traditional database form; and if not why? and what should it be normalised to. 2.< The detailed process of implementing the database using SQL, including the normalisation of the table (should that be required), the identification of the attributes, the Entity-Relationship Diagram, and the use of SQL commands in order to create and populate the tables with data If you're willing to help please reply or message needed urgently. Many thanks
-
Hi guys, just wanted to ask if anyone can help me determine whether a table should be: 1. Left in its traditional database form; and if not why? and what should it be normalised to. 2.< The detailed process of implementing the database using SQL, including the normalisation of the table (should that be required), the identification of the attributes, the Entity-Relationship Diagram, and the use of SQL commands in order to create and populate the tables with data If you're willing to help please reply or message needed urgently. Many thanks
-
Hi guys, just wanted to ask if anyone can help me determine whether a table should be: 1. Left in its traditional database form; and if not why? and what should it be normalised to. 2.< The detailed process of implementing the database using SQL, including the normalisation of the table (should that be required), the identification of the attributes, the Entity-Relationship Diagram, and the use of SQL commands in order to create and populate the tables with data If you're willing to help please reply or message needed urgently. Many thanks
Member 14182925 wrote:
what should it be normalised to.
BCNF (also 3.5NF). Steps are described on wikipedia.
Member 14182925 wrote:
The detailed process of implementing the database using SQL
We're not going to write a complete custom script and explain it.
Member 14182925 wrote:
including the normalisation of the table (should that be required),
Is always required for relational data.
Member 14182925 wrote:
and the use of SQL commands in order to create and populate the tables with data
If you don't know them, stay away from the database :thumbsup:
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
Hi guys, just wanted to ask if anyone can help me determine whether a table should be: 1. Left in its traditional database form; and if not why? and what should it be normalised to. 2.< The detailed process of implementing the database using SQL, including the normalisation of the table (should that be required), the identification of the attributes, the Entity-Relationship Diagram, and the use of SQL commands in order to create and populate the tables with data If you're willing to help please reply or message needed urgently. Many thanks
Member 14182925 wrote:
If you're willing to help
You are not asking for help, you are asking for someone to do your work for you. If you intend to learn this stuff then you are the one to do the research and find out how to meet the requirement.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
Member 14182925 wrote:
If you're willing to help
You are not asking for help, you are asking for someone to do your work for you. If you intend to learn this stuff then you are the one to do the research and find out how to meet the requirement.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
Reeks of homework to me....
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
-
Reeks of homework to me....
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
Almost certainly, any shortcuts taken now will mean you or I will be fixing his garbage in the future.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP