Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing Database Analytics

Authors: Andrew D. Banasiewicz

1st Edition

0415657881, 978-0415657884

More Books

Students also viewed these Databases questions

Question

What is loss of bone density and strength as ?

Answered: 1 week ago

Question

The paleolithic age human life, short write up ?

Answered: 1 week ago

Question

3. What are potential solutions?

Answered: 1 week ago

Question

4. I can tell when team members dont mean what they say.

Answered: 1 week ago