- Create a small companion webpage for the database
- Integrate text and image media into the information system
- Keep the webpage evidence clearly connected to the database evidence
- I can create a webpage that displays bike information
- I can include at least two media types: text and images
- I can explain why the database plus webpage forms one information system
Why a companion webpage?
National 4 requires evidence of integrating different media types. A MySQL database is strong evidence for structure and links, but the media evidence is clearer if you also create a simple webpage that displays text and images connected to the bike data.
The webpage does not need to be complicated. It should show useful information from your Bike Scotland database and include image media alongside text. This is a hybrid information system: database plus webpage.
Assessment Task
Practical Task 1 - Build the companion webpage
Create a file called bike_scotland_page.html. Save image files in the same folder. You may use your own suitable bike images or images supplied by your teacher.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Bike Scotland</title>
<style>
body { font-family: Arial, sans-serif; line-height: 1.6; }
.bike { border: 1px solid #999; padding: 12px; margin: 12px 0; }
img { max-width: 260px; height: auto; display: block; }
</style>
</head>
<body>
<h1>Bike Scotland</h1>
<div class="bike">
<h2>Ridge Runner</h2>
<img src="mountain-bike.jpg" alt="Mountain bike">
<p>Type: Mountain</p>
<p>Price: 425.00</p>
</div>
</body>
</html>Add at least two more bike sections using records from your database.
- Webpage contains text from or based on the database records (N4 O1.2)
- Webpage integrates image media alongside the text (N4 O1.2)
- Evidence includes the webpage code and a browser screenshot
- Short explanation links the webpage to the database structure (N4 O1.1/O1.2)
- Submitting only a database screenshot. N4 O1.2 needs media integration evidence too.
- Using an image without text context. The assessor should see how the media supports the information system.
- Breaking the image path. The image file must be in the expected folder and the
srcfilename must match exactly.
Task Set
1. Which two media types are used in the sample webpage? TYPE 1
2. Paste your webpage code or describe where it is saved. TYPE 3 N4
3. Explain how your webpage and database work together as one information system. TYPE 2 N4
Assessment standards covered: N4 O1.2, with supporting evidence for N4 O1.1. N3 pupils do not require this page for their Information Solutions unit.