help1402

It's UWAweek 47

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!" followup message.

How do I ask a good question?

Displaying the 5 articles in this topic

Showing 5 of 684 articles.
Currently 116 other people reading this forum.

UWA week 40 (2nd semester, week 10) ↓

Project 2 - Clarification on Submission Format: Including Schema and SQL Queries? (all 5)

2:38am Tue 1st Oct, ANONYMOUS

Hi everyone, I’m a bit confused about the submission format for our work. According to the submission webpage, it mentions that we need to submit a file in .txt format. However, when I convert my .db file to .txt, it only displays the tables and their values, but not the schema or the SQL queries that I’ve written. Are we supposed to submit the file showing just the tables, or should we also include the schema and the SQL queries used for the project? Any clarification would be greatly appreciated. Thanks in advance!

Project 2 - Clarification on Submission Format: Including Schema and SQL Queries? (all 5)

12:01pm Tue 1st Oct, Mehwish N.

Hi, You cannot submit a .db file because in a .db file we cannot see your code. Please create either a .sql or a .txt file to run your queries. Eventually, the final submission will be in .txt file. You can simple rename your .sql file. Cheers

Project 2 - Clarification on Submission Format: Including Schema and SQL Queries? (all 5)

4:14pm Tue 1st Oct, Seonghyeon L.

Hi, Thanks for your prompt response! However, when I try converting the .db file into .sql or .txt format (by using .output in terminal or simply renaming the file format from .db to .txt or .sql), the contents often break or show up as unreadable text. Should I still submit it in this format, or is there a specific way to ensure the code and schema appear correctly? Cheers!

Project 2 - Clarification on Submission Format: Including Schema and SQL Queries? (all 5)

9:45am Wed 2nd Oct, Seonghyeon L.

Problem solved! I ended up using python to generate CREATE TABLE and INSERT Statement.

Project 2 - Clarification on Submission Format: Including Schema and SQL Queries? (all 5)

10:23am Thu 3rd Oct, Adam W.

this may have been solved already by the original poster, but the intent of the 'use .txt/.sql' files is to submit a script file (.sql extension but it is essentially just a .txt file and opens in notepad easily), the script file will be able to be run in SQLite using the .read command and effectively build the database. the .db file is the actual built database, and can be used as well, but its cleaner and simpler to use a script and then build the .db ANONYMOUS wrote:

> Hi everyone, > > I’m a bit confused about the submission format for our work. According to the submission webpage, it mentions that we need to submit a file in .txt format. However, when I convert my .db file to .txt, it only displays the tables and their values, but not the schema or the SQL queries that I’ve written. > > Are we supposed to submit the file showing just the tables, or should we also include the schema and the SQL queries used for the project? > > Any clarification would be greatly appreciated. Thanks in advance!

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming