Question: DATABASE DESIGN, TABLE BUILDING, DATA MINING & QUERYING BUILD ME A DATABASE USING SQLite using the following data v 3 Excel Tables (.csv) o Table
DATABASE DESIGN, TABLE BUILDING, DATA MINING & QUERYING
BUILD ME A DATABASE USING SQLite using the following data
v 3 Excel Tables (.csv)
o Table #1 Data (5 of each)
EmployeeID (Primary Key)
EmployeeName
Company
Salary
o Table #2 Data Add
PositionTitle
o Table #3 Data Add
Age
v Import into SQLite and Build Database
v Use the following SQL Syntax
o WHERE
o SELECT
o FROM
o JOIN
o ORDER BY
v Final DB Build
o Show top-three employees by salary
o Show top-paying company
Build me a database on this information and you can send me the screen shots of the file and tables you gonna create on this database.
Thank You.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
