Did You _____ ?

  • Thread starter Thread starter Knightjester
  • Start date Start date
  • Christian Chat is a moderated online Christian community allowing Christians around the world to fellowship with each other in real time chat via webcam, voice, and text, with the Christian Chat app. You can also start or participate in a Bible-based discussion here in the Christian Chat Forums, where members can also share with each other their own videos, pictures, or favorite Christian music.

    If you are a Christian and need encouragement and fellowship, we're here for you! If you are not a Christian but interested in knowing more about Jesus our Lord, you're also welcome! Want to know what the Bible says, and how you can apply it to your life? Join us!

    To make new Christian friends now around the world, click here to join Christian Chat.
No, not in about 2-3 years I think... Last one was... uuuh... Pirates of The Carribians (the 2d one), if I'm not mistaken.

Did you see one you can recommend?
 
Not recently. I should do it. It's yummy stuff!

Did you ever made quiche?
 
No, it is considered stupid to get merried in Belgium. People just live together. Last marriage I got invited to was my brother's. I was his 'best man', and I had to sign all the papers! Yay!!!

Did you go to church today?
 
Yes I did. I just realised I have great friend: Brenna! :)

Did you see the sun today?
 
Yes, it's 32F here. The snow is melting and freezing again, wich is very slippery...

Did you have to wear one?
 
yes, it's - 14 C here (according to the internet, so it is probably slightly colder...)

did you have dinner yet?
 
yes, proper meat of some kind, rice and tomatoes.. lots of spices

did you know I failed my database assignment and have to redo it by friday? :(
 
yeah... had lots of syntax errors, and forgot to make it InnoDB, so nothing worked :S :p
 
yes it is MySQl

and HUH?

I created these tables:

 CREATE TABLE Kunde (KundeID CHAR(5) NOT NULL, Enavn VARCHAR (15), Fnavn VARCHAR (15), Adr VARCHAR (15), CONSTRAINT Kunde_pk PRIMARY KEY (KundeID)) ENGINE=InnoDB;
CREATE TABLE Produkt (ProduktID CHAR(5) NOT NULL, Beskrivelse VARCHAR (30), Farge VARCHAR (20), Pris INT(3), CONSTRAINT Produkt_pk PRIMARY KEY (ProduktID)) ENGINE=InnoDB;
CREATE TABLE Ordre (OrdreID CHAR (3) NOT NULL, Dato INT(6), KundeID CHAR (5) NOT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), Constraint Ordre_fk FOREIGN KEY (KundeID) REFERENCES Kunde(KundeID)); ENGINE=InnoDB;
but the last one fails, it says error 105 on the error handling thingy

CREATE TABLE Ordrelinje (OrdreID CHAR(3) NOT NULL, ProduktID CHAR (5) NOT NULL, Antall INT(3) NOT NULL, CONSTRAINT Ordrelinje_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordrelinje_fk1 FOREIGN KEY (OrdreID) REFERENCES Ordre (OrdreID), CONSTRAINT Ordrelinje_fk2 FOREIGN KEY (ProduktID) REFERENCES Produkt (ProduktID)) ENGINE=InnoDB;
I can't see what I am doing wrong :S
...and this is supposed to be the easy part!!!!

.. could of course just be me being stressed :p will ask the tacher about the InnoDB tomorrow, cause I really don't understand what it\s all about
 
wwjd_kilden said:
yes it is MySQl

and HUH?

I created these tables:

CREATE TABLE Kunde (KundeID CHAR(5) NOT NULL, Enavn VARCHAR (15), Fnavn VARCHAR (15), Adr VARCHAR (15), CONSTRAINT Kunde_pk PRIMARY KEY (KundeID)) ENGINE=InnoDB;
CREATE TABLE Produkt (ProduktID CHAR(5) NOT NULL, Beskrivelse VARCHAR (30), Farge VARCHAR (20), Pris INT(3), CONSTRAINT Produkt_pk PRIMARY KEY (ProduktID)) ENGINE=InnoDB;
CREATE TABLE Ordre (OrdreID CHAR (3) NOT NULL, Dato INT(6), KundeID CHAR (5) NOT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), Constraint Ordre_fk FOREIGN KEY (KundeID) REFERENCES Kunde(KundeID)); ENGINE=InnoDB;
but the last one fails, it says error 105 on the error handling thingy

CREATE TABLE Ordrelinje (OrdreID CHAR(3) NOT NULL, ProduktID CHAR (5) NOT NULL, Antall INT(3) NOT NULL, CONSTRAINT Ordrelinje_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordrelinje_fk1 FOREIGN KEY (OrdreID) REFERENCES Ordre (OrdreID), CONSTRAINT Ordrelinje_fk2 FOREIGN KEY (ProduktID) REFERENCES Produkt (ProduktID)) ENGINE=InnoDB;
I can't see what I am doing wrong :S
...and this is supposed to be the easy part!!!!

.. could of course just be me being stressed :p will ask the tacher about the InnoDB tomorrow, cause I really don't understand what it\s all about
Click to expand...

I'll have a look, but gotta go eat now. I'll give some feedback.
 
I just relized I have the same PK in two of the tables! LOL!!!!!!!!!!!!!!!!!!!!!!!!!!

but probably other errors there too...

the Ordrelinje (orderline(s)) is, unless I've misunderstood, supposed to add up to one Ordre (Order)
but I am not sure how to do that?

like...

Orderlines
1: 5 nails
2: 2 chairs
3: 7 pillows

is supposed to somehow be contained in one order? he assignments isn't really very clear on how we are to solve it :S

Order: 5 nails, 2 charis, 7 pillows ????
 
You must log in or register to reply here.
Top Bottom
Back