Faculty of Engineering and Mathematical Sciences 
Not logged in (login)


This forum is provided to promote discussion amongst students enrolled in Agile Web Development (CITS3403).
RSS cloud
Jump to:

Project 2 - Database Migrations, Schema Design, AJAX

1 of 419 articles shown, currently no other people reading this forum.
From: Timothy F.
Date: Wed 13th May 2020, 10:29pm


"Matthew Carter" <22*6*8*[email protected]*u*e*t*u*a*e*u*a*> wrote:

> Hi Tim, Tom and Haolin,
> The marking criteria for Project 2 states
> "Some evidence of DB migrations." 
> As part of the data models mark. Now my models.py file was not built in one go for sure. 
> However, while developing it if data was already inside the database and the 
> relationships or columns or tables were changed to a significant extent, the migration 
> would not occur, there where "ALTER TABLE" permission errors. To circumvent this error I 
> would delete the database and then rebuild it. How would I go about providing "some 
> evidence of DB migrations"? Or is it too late?

I think that's fine. Database migrations are a little bit flakey with sqlite.
> In addition, I am confident that the schema design is ok, however, this is just my 
> opinion. I am wondering if there are any resources I can use to check the quality of the 
> design you could refer me to.
There's some theory on database normalisation
Having 3rd normal form at least is good, but generally reducing fata redundancy and query 
complexity are the main goals.
> Thirdly, the marking criteria also talk about "DOM manipulation/AJAX". I can't think of 
> a reason to use AJAX and I was wondering if you could give me an example of how it would 
> be implemented in this project. For context, my group has built an application similar 
> to w3school with general web development trivia-style questions, with short answer 
> questions, multi-choice, and fill-in-the-blank question types.
Giving live feedback to any question without re-rendering the whole page would be done 
with DOM manipulations, and possibly AJAX as well. 

> Any help would be much appreciated.
> Cheers,
> Matt

Related articles

Project 2 - Database Migrations, Schema Design, AJAX (all 3) RSS
├─ original   Wed 13th May 2020, 7:54pm, Matthew C.
├─ THIS   Wed 13th May 2020, 10:29pm, Timothy F.
└─ reply 2   Thu 14th May 2020, 9:15am, Haolin W.
This Page

Program written by: [email protected]
Feedback welcome
Last modified: 11:27am Sep 21 2020