types of database to use with ocr a level computing programming project

Watch
thebgone
Badges: 7
Rep:
?
#1
Report Thread starter 2 years ago
#1
hi. so i'm nearly done with my programming project (it's a booking system for a dinner thing in a hotel) and I was wondering if I could use microsoft Access.
It kind of feels like cheating? i don't know. are we allowed to use it?
Thanks
0
reply
winterscoming
Badges: 19
Rep:
?
#2
Report 2 years ago
#2
You mean you've written an app in another language which needs a database back-end? Or are you looking to build the whole thing using MS Access using the Access forms?

I'd be careful about building the whole thing in Access forms because it'll be harder to meet the complexity requirements needed for A-Level unless you're going to be writing quite a lot of code behind the scenes using VBA.

However, if all you're using it for is just for the relational database with your tables, then there's really no difference between using Access compared with something like SQL Server or any other relational database. The only thing that Access gives you which isn't available in other databases are the Forms.
0
reply
thebgone
Badges: 7
Rep:
?
#3
Report Thread starter 2 years ago
#3
(Original post by winterscoming)
You mean you've written an app in another language which needs a database back-end? Or are you looking to build the whole thing using MS Access using the Access forms?

I'd be careful about building the whole thing in Access forms because it'll be harder to meet the complexity requirements needed for A-Level unless you're going to be writing quite a lot of code behind the scenes using VBA.

However, if all you're using it for is just for the relational database with your tables, then there's really no difference between using Access compared with something like SQL Server or any other relational database. The only thing that Access gives you which isn't available in other databases are the Forms.
Yeah I used python, i just need the backend to be in a database. I've made the interface and all the functionality in Python. I wrote up the data dictionary and drew the tables out and I have one linking table and I'll need a couple queries. Would I need to use Access SQL or can I just populate the tables with data and then do it without code?
Thanks
0
reply
winterscoming
Badges: 19
Rep:
?
#4
Report 2 years ago
#4
(Original post by thebgone)
Yeah I used python, i just need the backend to be in a database. I've made the interface and all the functionality in Python. I wrote up the data dictionary and drew the tables out and I have one linking table and I'll need a couple queries. Would I need to use Access SQL or can I just populate the tables with data and then do it without code?
Thanks
Whether you need to write SQL yourself to query the data really depends how complex it is, but the way you described it sounds something simple enough for the designer to handle. The designer is sometimes really bad at doing complex queries though.

Either way, if it's for anything linked back to your Python code, like a query where the app needs to read from the database, or where the app needs to insert/modify a row in the database, you'll need to cut+paste the SQL code that it generates into a string in Python anyway:
- https://stackoverflow.com/questions/...d-use-the-data


Also there's a downside to using Access which is that you can't actually get the raw script/DDL (Data Definition Langauge) which creates and seeds your database, so if you want the DDL for your report, then you'd need to import the Access Database into something like MySQL or SQL Server anyway. But if you do that, then you'd already have the full database in MySQL or SQL Server, so then there'd be no point in using MS Access

The only reason I could think of for using Access would be to create your database with the UI designer if you find that easier to do, and then import it into MySQL or SQL Server afterwards, but that seems pointless because those have got their own designer tools as well. But whatever works best for you really.

MySQL is here (Dev edition is free): https://dev.mysql.com/downloads/windows/ you'd need to download the MySQL database and Workbench UI/designer separately.

or SQL Server (Again, Dev edition is free): https://www.microsoft.com/en-gb/sql-...rver-downloads (make sure you install SQL Management studio too for the UI too)
Last edited by winterscoming; 2 years ago
1
reply
thebgone
Badges: 7
Rep:
?
#5
Report Thread starter 2 years ago
#5
Thank you so much, youre a godsend
(Original post by winterscoming)
Whether you need to write SQL yourself to query the data really depends how complex it is, but the way you described it sounds something simple enough for the designer to handle. The designer is sometimes really bad at doing complex queries though.

Either way, if it's for anything linked back to your Python code, like a query where the app needs to read from the database, or where the app needs to insert/modify a row in the database, you'll need to cut+paste the SQL code that it generates into a string in Python anyway:
- https://stackoverflow.com/questions/...d-use-the-data


Also there's a downside to using Access which is that you can't actually get the raw script/DDL (Data Definition Langauge) which creates and seeds your database, so if you want the DDL for your report, then you'd need to import the Access Database into something like MySQL or SQL Server anyway. But if you do that, then you'd already have the full database in MySQL or SQL Server, so then there'd be no point in using MS Access

The only reason I could think of for using Access would be to create your database with the UI designer if you find that easier to do, and then import it into MySQL or SQL Server afterwards, but that seems pointless because those have got their own designer tools as well. But whatever works best for you really.

MySQL is here (Dev edition is free): https://dev.mysql.com/downloads/windows/ you'd need to download the MySQL database and Workbench UI/designer separately.

or SQL Server (Again, Dev edition is free): https://www.microsoft.com/en-gb/sql-...rver-downloads (make sure you install SQL Management studio too for the UI too)
0
reply
shriller44
Badges: 2
Rep:
?
#6
Report 1 year ago
#6
For my project my teacher said to use a networked database, i installed mysql server but have no idea how to acess it from a second computer
0
reply
winterscoming
Badges: 19
Rep:
?
#7
Report 1 year ago
#7
(Original post by shriller44)
For my project my teacher said to use a networked database, i installed mysql server but have no idea how to acess it from a second computer
How are you connecting to it from the same computer? There's actually no difference at all when connecting from another computer; if you're able to get it working when connecting using localhost or the loopback IP address (127.0.0.1) from the same computer, then you can connect to it from another computer using its network hostname or network IP address in the same way.

But you don't really need to connect to it from a second computer anyway since it's all the same thing, the code you'll be writing will be identical if you run everything on the same computer, so it doesn't make any difference to your solution or to your project.
Last edited by winterscoming; 1 year ago
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Do you think receiving Teacher Assessed Grades will impact your future?

I'm worried it will negatively impact me getting into university/college (71)
37.57%
I'm worried that I’m not academically prepared for the next stage in my educational journey (19)
10.05%
I'm worried it will impact my future career (12)
6.35%
I'm worried that my grades will be seen as ‘lesser’ because I didn’t take exams (47)
24.87%
I don’t think that receiving these grades will impact my future (25)
13.23%
I think that receiving these grades will affect me in another way (let us know in the discussion!) (15)
7.94%

Watched Threads

View All
Latest
My Feed