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

help3403


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

Project 2 - Database Migrations, Schema Design, AJAX

1 of 419 articles shown, currently no other people reading this forum.
photo
From: Timothy F.
Date: Wed 13th May, 10:29pm
Actions: 
        Login-to-reply
"Matthew Carter"                               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
https://en.wikipedia.org/wiki/Database_normalization
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, 7:54pm, Matthew C.
├─ THIS   Wed 13th May, 10:29pm, Timothy F.
└─ reply 2   Thu 14th May, 9:15am, Haolin W.
This Page


Program written by: [email protected]
Feedback welcome
Last modified:  8:27am May 24 2020