Question

Database problem

Answer 1

@malihe please ask your problem her & my sister @lalaly will help you :)

Answer 2

*here

Answer 3

plz see the er diagram in file, i want to insert order of a customer which is first order a product, i related tables must change

Answer 4

Malihe can you please translate the problem my sister can't understand persian :D

Answer 5

i'll be back in 5 minutes, my laptop just needs a restart coz i just updated it .. so brb

Answer 6

okie :)

Answer 7

oh I get the problem :)
she want to insert a record in table order which is related to other tables too so she dont know how to quirie that :)

Answer 8

Problem statement: she wants to place a new order but before inserting this order into the table she wants to insert the related information in the other relavent table

Answer 9

someone please help

Answer 10

Its my friends question & tomorrow is her exam

Answer 11

malihe i think it will go like this:
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
first you will insert a new customer
then you will make it sure that the product exist in product table
then you place order details & in the end you'll place the order
this is what I think dear

Answer 12

ewwww windows dba

Answer 13

you are missing a lot of information: order status, tracking, and delivery etc etc

Answer 14

man its not my work its my friend's @malihe work

Answer 15

@nincompoop can you help her :) kindly use easy english :)

Answer 16

I don't know how complex or simple you want your database to be. For generic purposes, first, have a goal in mind how the database should flow from an employee's/store perspective to entering information and then customer's perspective to receiving information

there's the customer record
basic demographic
invoice record
discounts
returns
cancellation
payment record
balance per order
total balance in the account

interaction or notes and alerts

there are employees accessing or entering order information and there are also employees just receiving payments

product records require inventories such as stocks, back-order

every goods are either picked up or delivered, consider this also

complexity increases depending on the store set-up

Answer 17

first things first, what database manager system are you using?

Answer 18

she is using mysql

Answer 19

i want to write the sql eqivalent code in java

Answer 20

mysql has an automation for a first record entry so long as you set up the order_id

Answer 21

hmm but nini she wants java code to insert the record

Answer 22

java will just pull the records from the server, it just displays them as a text so you needn't worry about that part

you want to append or prepend? these are the two types of record insertion

Answer 23

i use this code to insert :statement.executeUpdate("INSERT INTO Employee VALUES (134, 'zohreh','amini','seller','144')")

Answer 24

insert into command

Answer 25

stmt.executeUpdate(sql);
sql = "INSERT INTO ...

Answer 26

yes i know that

Answer 27

so what is the trouble you're running into?

Answer 28

i know how to insert in 1 table but as you see my question above and see the er diagram, i don't know how to write this query (insert order of a customer which is first orders a product)

Answer 29

nini she means she dont know how to write a nasted query that will insert a new order of a customer for a product that already exist :)

Answer 30

Malihe you will use a "nasted query" search this one on google

Answer 31

SELECT *
FROM (
select (select A from B where ... ) as C from D
) subq
WHERE
C like ' ... '

Answer 32

i know this , but i don't see this use for insert anywhere

Answer 33

you can use it in the same way for insert

Answer 34

INSERT INTO Orders VALUES (.....) where custID ... smoething like this

Answer 35

INSERT INTO Staffs VALUES(....)
WHERE EXISTS (SELECT *
FROM Branch b
WHERE s.branchNo = b.branchNo
AND city = ‘London’
);
this is proper syntax

Answer 36

I found it :D

Answer 37

now can you try it for your tables ?