year 13 m1

Referential integrity enforces that the relationships between tables relevant, consistent and valid, and that no invalid links exist between tables. Foreign keys allow you to define relationships between tables in a database. A primary key is unique and is used to keep track specific data when there is more than one of the same piece of data, for example, when there are two books of the same name in a library, the bar codes would be of each of these would be unique. Searching for the unique bar code in the database would be quicker and easier than searching for the genre.

year 13 p1

Year 13 what is a database

M2

Processor: I would choose the Intel core i7 processor as it is capable of working at high speeds, is good for multitasking and well suited for media creation. The price is only £257.00 which is relatively cheap for a processor. The only downfall is that processors are upgraded all the time.

Motherboard: I would choose the ASUS P8Z77 as it runs at a high performance, it improves graphics thanks to the LucidLogix Virtu MVP which features HyperFormance technology, this can improve the performance of the graphics card by 60% and the Usb 3.0 technology boosts your USB device's transmission speeds. The price for this motherboard is only £89.99.

Graphics card: I would choose the Gigabyte NVIDIA GTX660 2GB DDR5 PCI-E Graphics Card. This is great for gaming and this means that it will also be good for graphic design. It is £150.00 which is easily affordable.

Case: I would choose the CiT Vantage Type-R Gaming Case with HD Audio, 4 Fans, Card Reader and No PSU - Black. It features a Card Reader supporting SD/MMC/MS, HD Audio & 2 x USB 2.0 and features a powerful cooling system. It is also relatively cheap at £35.

Power supply: I would chose the Corsair CX750 Builder Series CX 750W ATX/EPS 80 PLUS Bronze PSU as it supplies a good amount of power to the computer's components, generates less heat than most power supplies and gives out less noise. The price is £66.99 which is easily affordable.

Cooling system: I would choose the Corsair CW-9060007-WW Hydro Series H60 2013 High Performance 120mm Rad All-In-One Liquid CPU Cooler. The system is very quiet and offers good cooling performance for £56.65 which is relatively cheap.

Hard drive: I would choose the Seagate 3TB 3.5 inch 7200RPM 64MB Cache SATA3 Hard Drive as it has 3 terabytes of storage which will easily hold the data of one person and even many others and only costs around £95.

Monitor: I would choose the Samsung S22B150 21.5 inch Widescreen LED Monitor - Gloss Black (1920 x 1080 Full HD, 5ms, VGA) as it uses full HD for maximum image quality which would be perfect for graphic design and at £98.80 it is easily affordable. 

The other system:

HP Pavilion h9-1250ea Desktop (Intel Core i7-3770 Processor, 12 GB RAM, 2 TB HDD, Windows Home Premium)

£1,129.42

Brand	Hewlett Packard
Item Weight:	12 Kg
Product Dimensions	17.5 x 41.2 x 41.5 cm
Item model number	B7H87EA#ABU?AMAZON
Colour	Black
Processor Brand	Intel = Intel is known for making good processors
Processor Type	Intel Core i7. This is a very popular processor in the gaming community because of its ability of handling large amounts of data needed for gaming; this should be more than capable for graphic design.
Processor Speed	3.4 GHz
RAM Size	12 GB, This can handle a lot of data, this should be suitable for graphic design as it should be able to keep multiple design programs running at full speed.
Computer Memory Type	DDR3 SDRAM
Hard Drive Size	2 TB, the size of this hard drive should be able to store plenty of work.
Graphics Card Description	AMD Radeon HD 7770
Graphics RAM Type	DDR3 SDRAM
Graphics Card Ram Size	2 GB, Can handle high quality graphic imaging.
Operating System The top system should be bought instead of the bottom as when they are compared, the top is cheaper than the bottom. Some of the features of very similar but when comparing the hard drive size, the top is larger than the bottom. Although the monitor is smaller, it still works at the same quality resolution and is much cheaper.	Samsung S24B300HL 23.6 inch Widescreen LED Monitor - Gloss Black (1920 x 1080 Full HD, 5ms, HDMI/VGA) £119.98 Slim LED HDMI Feature 5ms Mega DCR Black Gloss This monitor allows you to view work at a full HD quality and the hdmi port compatibility makes it possible to use this product at full resolution. Windows 7 Edition Home Premium, is capable of running high quality design programs.

m3 d2

The Packard bell could be easily improved by increasing the amount of RAM of the computer system. This would speed up the overall system of the computer. The graphics card can be easily changed to improve the graphics. The processor can be improved to make allow the computer to run faster and smoother.

The MacBook Pro processing unit can be upgraded to increase system performance and will help to allow the system to run smoother and faster. The best upgrade to the processor would be a 2.7GHz quad core processor. This is an expensive upgrade costing £2,299, this is £1,050 more than the cheapest upgrade. Cheaper upgrades are available.