CS6: Assignment on Database

Answer All Questions

1(a) What is a flat file database? (01 mark)

(b)    Mention any two advantages of using electronic database system (02 marks)

(c)     State two characteristics of a good database design (02 marks)

2.(a). Explain the following field properties as used in database design. (04 marks)

(i).Caption

(ii).Input mask

(b). Give one requirement of a good primary key field in a database table. (01 Mark)

3. (b) A property owner uses a database to store data about houses he sells. The table shows part of the database.

• The records shown are to be sorted in ascending order of price. What will be the reference number of the first record in the database after it has been sorted? (01 mark)

(ii) Give the names of the fields that contain Boolean data type. (01 mark)

Identify the field type of the reference number field. (01 mark)

(iv) Give two validation checks that could be carried out on the reference number field. (01 mark)

(v)  Which field should be the primary key of the database table? (01 mark)

4.(a) (i) What a wild card is in database management system. (01 mark)

(ii) Importance of a wildcard in a query criterion (01 mark)

(iii)   Naming examples of frequently used wildcards. (01 mark)

(b) Give two advantages of using a primary key in a database. (02 marks)

5. Create a database for Jinja Bridal Car Hire Ltd saved as bridal and carry out the following tasks. (20 marks)

Instructions:

(a).   Design a table saved as drivers to hold the above data.

(b).  Using appropriate field, assign a primary key.

(c).  Design a form having a sky-blue background colour, footer of your name you will     use to populate the table. Save the form as Data Entry.

(d).   Design three queries that will return workers who:

(i). have no remarks against their records. Save the query as Not Appraised.

(ii).   drive Car_Type that is not a Wish. Save the query as Not Wish.

(iii). celebrate birth day in the month of January. Save the query as Born Jan.

(e). Create a report to return drivers who drive a premio Car_Type. Save the report as Premio.

(f) Create a report having all the records on one sheet. Save the report as All. The report should have the following details:

(i). A good red line boarder.

(ii). Count of the records it holds                                                                          

(iii). Group and sort your records in order of car_type

(iv). Add a title: MOTO VEHICLES INFORMATION REPORT size 24

(g) Add Header as Your Name and Your Gender as Footer on the report

(h) Add an image on your report to serve as a  logo

(h) Print your queries and report only.

6. Using any data base management system load file called 20xxxCoMpany. Mdb and use it to answer the following questions. Any changes made should be saved. (20 marks)

• Open up table  called suplaya in design view and adjust the data type appropriately
• Change the default primary key field to the most appropriate field
• Change the date format in the table properties to medium date
• The currency field should be formatted to indicate SHS as units
• Create a tabular form that includes all the fields that can be used to add more information in the table. Save it as entry
• If all suppliers offered a general discount of 0.2% use a form above to determine how much discount the company enjoyed from each supplier
• Change the background color of your form to a brighter color
• Insert a header on the page of the form
• Create a query with only the field of SUPNAME and PRODUCAT to filter those who supplied meals, stationary or text books and save it as power
• Create another query that will filter suppliers who supplied items during 1998 and after 2014. Save it as yearly
• Create on other query with a field of supname and cost to display those suppliers whose items were not valued and names start with letter K. Save it as valueless
• Create a general report with supplier name sorted in ascending order with a header of your name and index number. Save it as
• Print the genrepo on a landscape page orientation.