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 2 articles in this topic
Showing 2 of 684 articles.
Currently 136 other people reading this forum.


 UWA week 32 (2nd semester, week 3) ↓
SVG not supported

Login to reply

👍x1
helpful
2:06pm Sun 11th Aug, ANONYMOUS

Good day, Just a feedback or personal opinion that might help student to attempt the lab questions or improve the understanding of the question. 1. Dataset to attempt the questions 6 to 11 For question from 6 to 11, it would be helpful if small dataset is provided for student to understand the whole data schema and have a better visualization on data that stored in the tables. For example, in Q7, I do understand that PK is item_id and logically each item_id will have a unique description, however in this table, description column may have same name as it does not check unique value in this column. If it is same name, one might use exact match or one might use wild card to do matching. Cheers


SVG not supported

Login to reply

👍x2
helpful
8:48pm Sun 11th Aug, Mehwish N.

Very good suggestion :) I have upload a file on moodle as well as one under week 4. You need to create all your tables first before you attempt to load data. Once you have created the tables, use the following command to load the data: .read printing-dat.sql Cheers Mehwish

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy