COSC 1300 E1 - Create a database Item with the following table and Create the following list

 

Instructions:

1.      Save your file in doc format (Name_ID) eg: Ahmed_20182242.docx

2.      Each question carries 10 marks.

3.      Question 1: Capture the output screen shot, paste and crop it in the related space.

4.      Question 2 : Copy and paste the source code and capture the output screen shot in the related space.

5.      Finally upload your same MS word file through Eduoasis.

 

Question 1:   10 marks

1.       Create a database Item with the following table:                                                              (4 marks)

 

a.       Item Table for adding Student data at least 5 records

 

Field

Data Type

Description

IID

Number

Item ID, Primary key

IName

Text

Item Name

ICode

Text

Item Code

Start with ‘abc’ and total 6 letters

ICat

Text

Item Category:

Lookup: very old, old, new

IDateBought

Date

Date Bought

Previous and todays date only

IQty

Number

Item Quantity

Validation: greater than zero

IPrice

Number

Item Price

ICountry

Text

Country made the item:

Lookup: Oman, Emirates, Saudi, Kuwait

Default Value: Oman

 

Paste the screen shot for the table design view below:

 

2.       Queries                (2 marks each)

a.       Search for Items (IID, IName,ICat, IQty)

Paste the screen shot for the Query 1 design view below:

 

b.      Search for Items(IID,IName,IQTY,IPrice).

 

Paste the screen shot for the Query 2 design view below:

  

3.       Reports                (2 marks)

a.       Create a report that shows Items (IID, INAme,ICat, IQty) 

Paste the screen shot for the running Report below:

 

  

Question 2:   10 marks

a. Create the following list (list.html)                                                                                       (5 marks)

List of Courses

1.       Java programming

a.       History

b.      Features of OOP

c.       Encapsulation

2.       Computer Applications in Business

a.       MS Access

b.      HTML

c.       MS Excel

3.       Visual Basic Programming

a.       Integrated Development Environment

b.      Visual Application Development

c.       Data Types

 

         List                                table

 

Paste the html code for the list page below:

 

Paste the screen shot for the list page below:

  b. Create the following html table (table.html)                                                                 (5 marks)

Add MCBS Logo here

 

 

 

 

 

 

          List                               table

 

Paste the html code for the table page below:


Paste the screen shot for the table page below: 

Answer Preview

attachment

<ol type='1'>

  <li>Java programming</li>

<ol type='a'>

  <li>History</li>

  <li>Features of OOP</li>

  <li>Encapsulation</li>

</ol>

  <li>Computer Applications in Business</li>

  <li>Visual Basic Programming</li>

</ol>



Output
  1. Java programming
    1. History
    2. Features of OOP
    3. Encapsulation
  2. Computer Applications in Business
  3. Visual Basic Programming
This is only a preview of the solution. Please use the purchase button to see the entire solution