Please help me with this question. Explainbriefly.
Q) Reduce the E-R diagrams below to a collectionof table schemas (i.e. the name of each table and itsattributes/columns). Do not include any redundant tables.
–>
WE WRITE PAPERS FOR STUDENTS
Tell us about your assignment and we will find the best writer for your project
Write My Essay For Me–>
–>
balance ssn (name (address customer account odate has We were unable to transcribe this imageWe were unable to transcribe this imageShow transcribed image text balance ssn (name (address customer account odate has
Expert Answer
Dear Student ,
As per the requirement submitted above , kindly find the belowsolution.
This demonstration is using SQL Server 2014.Database and tablesare created using SQL Server Management Studio (SSMS).
Tables forfirst two diagrams :
1.Table Name:Customer
Description :This table store customer detailssuch as ssn , name and address
Schema :Customer (ssn,name,address)
Here ssn is primary key.
Create table SQL Statement :
Create table Customer(
ssn int primary key,
name varchar(50) not null,
address text not null
);
********************************
2.Table Name:Account
Description :This table stores account detailssuch as accountnum,type,balance and odate.
Schema :Account(accountnum,type,balance,odate,ssn)
- Here accountnum is primary key.
- ssn is foreign key which indicates owner of account.
- Each account has opening date and customer ssn associated withit.
Create tableSQL statement:
create table account(
accountnum int primary key,
type varchar(50) not null,
balance decimal(8,2) not null,
odate date not null,
ssn int ,
foreign key (ssn) references customer(ssn)
);
***************************************
Table for thirdDiagram :
1.Table Name:Customer
Description :Thistable stores customer data which includes idum,name,address andphone.
Schema:Customer(idnum,name,address,phone)
Create table SQL Statement:
create table customer (
idnum int primary key,
name varchar(50) not null,
address text not null,
phone varchar(20) not null
);
***************************
2.Table Name:Salesperson
Description :Thistable stores sales details for salesperson
Schema :SalesPerson(idnum,name,address,phone)
Create table SQL Statement:
create table Salesperson (
idnum int primary key,
name varchar(50) not null,
address text not null,
phone varchar(20) not null
);
*******************************
3,Table Name:Sales
Description :Thistable stores sales data which includes salesperson idnum, customeridnum and price.
Schema :Sales(saleId,Custmeridnum,SalespersonIdnum,price)
Create table SQL Statement:
Create table sales(
saleID int primary key,
Custmeridnum int,
SalespersonIdnum int,
price decimal(8,2),
foreign key(Custmeridnum) references customer(idnum),
foreign key (SalespersonIdnum) references salesperson(idnum)
);
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THESOLUTION.
I lOVE this Professional essay writing website. This is perhaps the fifth time I am placing an order with them, and they have not failed me not once! My previous essays and research papers were of excellent quality, as always. With this essay writing website, you can order essays, coursework, projects, discussion, article critique, case study, term papers, research papers, research proposal, capstone project, reaction paper, movie review, speech/presentation, book report/review, annotated bibliography, and more.
Post your homework questions and get original answers from qualified tutors!