preview

Unit 18 Database Design Oliver Taylor Resubmission

Good Essays

Unit 18

Task 1 - What are the benefits of a relational database?
A benefit of a relational database would be that the data is only stored once. This means you don’t have to change multiple records and it doesn’t take up much storage space. For the veterinary practise this is ideal for them, as this is the main reason to why they’re changing from paper to Microsoft Access. Having everything on Access and not on paper means they can search for information quicker through the search bar and also it can all be stored on a hard drive. This will save money on buying filing cabinets, on storage space, time spent looking for information and on buying materials such as paper and ink.

Another benefit would be its more secure. This is because …show more content…

If the field size is ‘70’, that means the user can input up to 70 letters, numbers or symbols. It’s important that you change it field size if it’s the automatically the appropriate size. This is because if you have a field size of 70, that’ll take up 70 bytes of storage, which by itself isn’t a lot, but over a massive database that’ll take up a lot of room. So for a First Name for example, instead of leaving it as 70, it should be changed to around 10-15.

One to One relationship

A one to one relationship in a database is where each row in a database is linked with another database. Only one can be linked with another from another table. For example in Table A and Table B, each row in Table has to be linked with another row in Table B. In each of them, they must have the same number of rows, otherwise it won’t work. This does make it sound like you could just merge the two tables into one, which in theory is true. But the advantage of having two separate tables is that if you have columns of data that you don’t often use then you can separate them into another table. This will make information in the primary table easier to read as it will only have the relevant information in it.

One-to-many relationships
A one-to-many database relationship is where each row in a table can be related to many other rows in another table. With being able to do this you can use frequently used data from one data and reference it many

Get Access