New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now

7810ict software technologies

  • Subject Code :  

    7810 ICT

  • Country :  

    AU

  • University :  

    Griffith University

Task 1 – Access the workbooks and create a database

Create a Python script (createdb_food.py) to perform the following tasks:
? Open the excel files.
? Create a SQLite database with two tables, one for each excel file. Each column in the excel files should correspond to a column in the tables. Make sensible decisions for attribute types.
? Import the data from the excel files to the corresponding tables in the database.
Task 2 – Query the database
Create a Python script (sql_food.py) to perform the following tasks:
? List the distinctive businesses that have had at least 1 violation ordered alphabetically to the console and then write their name, address, zip code and city into a new database table called “Previous Violations”.
Get An Awesome Price Quote For Your Paper – Absolutely FREE!
    Add File
    Files Missing!

    Please upload all relevant files for quick & complete assistance.

    Getting started with MyEssayAssignmentHelp is FREE

    15,000+ happy customers and counting!

    Rated 4.7/5 based on
    1491 reviews
    Order Now
    Have any Query? Contact with us
    ;