Table Relations: Problem 5 Problem 5. Online Store Database

GallinaSt 2 Точки

Table Relations: Problem 5 Problem 5. Online Store Database

Как да разбера кой е Тест 3, на който ми гърми кода? Ето го и него, диаграмата изглежда по същия начин (моята) ... Не мога да дебъгна, ако не знам какво гърми :)

create table Cities(
CityID int, 
Name nvarchar(50),
constraint PF_Cities primary key (CityID));


create table Customers(
customerID int,
Name nvarchar(50),
Birthday date,
CityId int, 
constraint PF_Customers primary key(CustomerID),
constraint FK_Customers_Cities foreign key (CityID)
references Cities(CityID));

create table Orders(
OrderID int,
CustomerId int,
constraint PK_Orders primary key(OrderId),
constraint FK_Orders_Customers foreign key(CustomerID)
references Customers(customerID));


create table ItemTypes(
ItemTypeID int,
Name nvarchar(50),
constraint PK_ItemTypes primary key(ItemTypeID));

create table Items(
ItemID int, 
Name nvarchar(50),
ItemTypeID int,
constraint PK_Items primary key(ItemID),
constraint FP_Items_ItemTypes foreign key(ItemTypeID)
references ItemTypes(ItemTypeID));

create table OrderItems(
OrderId int, 
ItemID int,
constraint PK_OrderItems primary key(OrderID, ItemID),
constraint FK_OI_Orders foreign key (OrderID)
references Orders(OrderID),
constraint FK_OI_Items foreign key(ItemID)
references Items(ItemID));

Тагове:

10/10/2016 14:58:56 Module: Java DB 13/10/2016 20:44:39

vancho 430 Точки

На мен с твоя код ми дава 0/100 т. А и кода изобщо не е четим или написан по стандатртите на MySQL!

-1

10/10/2016 15:19:19

GallinaSt 2 Точки

Благодаря за отговора, Judge ме разбра. Очевидно не ме проверява за краснопис ;)

11/10/2016 15:18:27

a_dimitrov 20 Точки

Аз пък минавам само първия тест и нямам представа защо :-) Някой ако има идея??? Ще съм благодарен


CREATE DATABASE online_store_database;

CREATE TABLE cities
(
city_id INT PRIMARY KEY,
name VARCHAR(50)
);

CREATE TABLE item_types
(
item_type_id INT PRIMARY KEY,
name VARCHAR(50)
);


CREATE TABLE customers
(
customer_id INT PRIMARY KEY,
name VARCHAR(50),
birthday DATE,
city_id INT, 
CONSTRAINT fk_customers_cities FOREIGN KEY(city_id)
REFERENCES cities(city_id));


CREATE TABLE items 
(
item_id INT PRIMARY KEY,
name VARCHAR(50),
item_type_id INT, 
CONSTRAINT fk_items_item_types FOREIGN KEY(item_type_id)
REFERENCES item_types(item_type_id)
);

CREATE TABLE order_items
(
order_id INT PRIMARY KEY,
item_id INT,
CONSTRAINT fk_order_items_items FOREIGN KEY(item_id)
REFERENCES items(item_id)
);

CREATE TABLE orders
(
order_id INT PRIMARY KEY, 
customer_id INT, 
CONSTRAINT fk_orders_customers FOREIGN KEY(customer_id)
REFERENCES customers(customer_id),
CONSTRAINT fk_orders_order_items FOREIGN KEY(customer_id)
REFERENCES order_items(order_id)
);

12/10/2016 16:07:32 13/10/2016 20:45:18

pavelp 1 Точки

Ще пуснеш ли правилното решение?

13/10/2016 20:25:59

GallinaSt 2 Точки

Da, eto:

create table Cities(
CityID int,
Name nvarchar(50),
constraint PF_Cities primary key (CityID));

create table Customers(
customerID int,
Name nvarchar(50),
Birthday date,
CityID int,
constraint PF_Customers primary key(CustomerID),
constraint FK_Customers_Cities foreign key (CityID)
references Cities(CityID));

create table Orders(
OrderID int,
CustomerID int,
constraint PK_Orders primary key(OrderID),
constraint FK_Orders_Customers foreign key(CustomerID)
references Customers(customerID));

create table ItemTypes(
ItemTypeID int,
Name nvarchar(50),
constraint PK_ItemTypes primary key(ItemTypeID));

create table Items(
ItemID int,
Name nvarchar(50),
ItemTypeID int,
constraint PK_Items primary key(ItemID),
constraint FP_Items_ItemTypes foreign key(ItemTypeID)
references ItemTypes(ItemTypeID));

create table OrderItems(
OrderID int,
ItemID int,
constraint PK_OrderItems primary key(OrderID, ItemID),
constraint FK_OI_Orders foreign key (OrderID)
references Orders(OrderID),
constraint FK_OI_Items foreign key(ItemID)
references Items(ItemID));

14/10/2016 10:16:30

pavelp 1 Точки

Мерси, на мен грешката ми беше че вместо 'create table ItemTypes' съм написал 'create table ItemsTypes'...заради една буква...

14/10/2016 11:41:45