Question
This is for SQL: create table Manufacturer ( manufacturer_id int primary key auto_increment, name varchar(50), registered_country varchar(40), contact_person_id int not null foreign_key(contact_person_id) references user(user_id) );
This is for SQL:
create table Manufacturer (
manufacturer_id int primary key auto_increment,
name varchar(50),
registered_country varchar(40),
contact_person_id int not null
foreign_key(contact_person_id) references user(user_id)
);
create table User (
user_id int primary key auto_increment,
username varchar(50),
password varchar(50),
first_name varchar(50),
middle_name varchar(50),
last_name varchar(50),
address varchar(50),
officephone varchar(50),
cellphone varchar(50),
email varchar(50)
);
create table TestLab (
testlab_id int primary key auto_increment,
name varchar(50),
address varchar(50),
contact_person_id int not null
foreign_key(contact_person_id) references user(user_id)
);
create table TestResults (
testresults_id int primary key auto_increment,
datasource_id not null
foreign_key(datasource_id) references testlab(testlab_id),
product_id not null
foreign_key(product_id) references product(product_id),
reportingcondition varchar(50),
testsequence varchar(50),
testdate date(50),
isc float,
voc float,
imp float,
vmp float,
pmp float,
ff float,
noct float
);
create table Product (
product_id INT primary key auto_increment,
model_number varchar(50),
manufacturer_id not null
foreign_key(manufacturer_id) references manufacturer(manufacturer_id),
manufacturing_date date(50),
length float
width float
weight float
cell area float
cell_technology varchar(50),
total_number_of_cells int,
number_of_cells_in_series int,
number_of_series_varchar(50)s int,
number_of_bypass_diodes int,
series_fuse_rating float,
interconnect_material varchar(50),
interconnect_supplier varchar(50),
superstrate_type varchar(50),
superstrate_manufacturer varchar(50),
substrate_type varchar(50),
substrate_manufacturer varchar(50),
frame_material varchar(50),
frame_adhesive varchar(50),
encapsulant_type varchar(50),
encapsulant_manufacturer varchar(50),
junction_box_type varchar(50),
junction_box_manufacturer varchar(50),
junction_box_adhesive varchar(50),
cable_type varchar(50),
connector_type varchar(50),
maximum_system_voltage float,
rated_voc float,
rated_isc float,
rated_vmp float,
rated_imp float,
rated_pmp float,
rated_ff float
);
I'm receiving the errors:
Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ','. Msg 102, Level 15, State 1, Line 23 Incorrect syntax near ','. Msg 102, Level 15, State 1, Line 31 Incorrect syntax near ','. Msg 102, Level 15, State 1, Line 49 Incorrect syntax near ','.
Any help would be great.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started