A. Create data base tables, purchase inventory, purchase inventory/inventory tab

Question

A. Create data base tables, purchase inventory, purchase inventory/inventory table not all feilds will be used.

Available feilds

vendor phone    purchasing agent ID    vendor ID     purchasing agent home address     vendor address     transaction date    Inventor Discription

Cost per item    Vendor Code     invoice total payment terms     tranaction number     Quanity purchased

B. Create open bank account table and account holder/account table not all feild may be used

Bank account type     Current balance     date account created    transaction type     transacion amount    Employee ID     Total interest earned in current year

Account number    account holder names    Identify verfied?    Transaction date       Account holder address    Annual interest rate    Account holder Email

C. Create register for courses table, Register for courses/course table

Student ID      Crourse ID    Course Title   Registration transaction number    Total students currently enrolled    Faculty ID number    Corse Prefix and number

Maximum enrolllment     Regisration date     Average GPA students enrolled.

Explanation / Answer

Please find the asked quries below :

CREATE TABLE purchase_inventory
(
vendor_phone varchar(15),
purchasing_agent_id int,
vendor_id int,
purchasing_agent_home_address varchar(255),
vendor_address varchar(255),
transaction_date timestamp,
inventor_discription varchar(255)
);

CREATE TABLE inventory
(
cost_per_item int,
vendor_code varchar(15),
invoice_total int,
payment_terms varchar(255),
transaction_number int,
quanity_purchased int
);

CREATE TABLE bank_account
(
bank_account_type varchar(15),
current_balance int,
date_account_created timestamp,
transaction_type varchar(15),
transaction_amount int,
employee_id int,
total_interest_earned int
);

CREATE TABLE account_holder
(
account_number varchar(15),
account_holder_names int,
identify_verfied timestamp,
transaction_date varchar(15),
account_holder_address int,
annual_interest_rate int,
account_holder_email int
);

CREATE TABLE course_register
(
student_id int,
course_id int,
course_title varchar(50),
registration_transaction_number int,
total_students_enrolled int,
faculty_id int,
course_prefix_number varchar(15),
maximum_enrollment int,
registration_date timestamp,
average_gpa int
);

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.