Scribd Logo
Upload

Welcome to Scribd!

  • 131 views

    Proj Report

    Uploaded by

    developer.dtt
    1. Download the CET information brochure and application form from the website. 2. Submit the completed application form and Rs. 1000 exam fees to your college during the registration period. 3. The CET exam will consist of 4 sections covering Math, Logic, English, and Computers with 200 total marks over 120 minutes and a negative marking system.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Proj Report

    Uploaded by

    developer.dtt
    131 views6 pages
    1. Download the CET information brochure and application form from the website. 2. Submit the completed application form and Rs. 1000 exam fees to your college during the registration period. 3. The CET exam will consist of 4 sections covering Math, Logic, English, and Computers with 200 total marks over 120 minutes and a negative marking system.

    Original Title

    ProjReport.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. Download the CET information brochure and application form from the website. 2. Submit the completed application form and Rs. 1000 exam fees to your college during the registration period. 3. The CET exam will consist of 4 sections covering Math, Logic, English, and Computers with 200 total marks over 120 minutes and a negative marking system.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    131 views6 pages

    Proj Report

    Uploaded by

    developer.dtt
    1. Download the CET information brochure and application form from the website. 2. Submit the completed application form and Rs. 1000 exam fees to your college during the registration period. 3. The CET exam will consist of 4 sections covering Math, Logic, English, and Computers with 200 total marks over 120 minutes and a negative marking system.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 6

    Project Report

    Project Description
    The requirements of an incoming repair job are logged in the Repairs File. Each job is
    assigned a job reference number and may be for a new customer or an existing customer.
    For new customers, the customer details are recorded in the Customer File. A job is for only
    one ‘Repair ID’ but a customer may have several jobs on-going at the same time.

    PC Solution is considering implementing a computerised system to handle their staffs,


    customers, repairs, inventory and account records. The following is a description of the
    system:
    Details of all the Staff, including managers, interns and normal staff, is recorded in the Staff
    File.Each staff is identified by a unique staff ID and has staff details – surname, forename,
    DOB, gender, address1, address2, town, county, telephone, mobile, e-mail, staff type and
    status. The company has the ability to Add, Amend and List the details of all the staff in the
    Staff File.
    The requirements of an incoming repair job are logged in the Repairs File. Each job is
    assigned a job reference number and may be for a new customer or an existing customer.
    For new customers, the customer details are recorded in the Customer File. A job is for only
    one ‘Repair ID’ but a customer may have several jobs on-going at the same time.
    SELECT

    SELECT DISTINCT c.cust_id, c.surname, c.forename, c.town, c.county, c.tel FROMcustomers


    c ORDER BY c.cust_id;

    Location: ajax/getCustomers.php

    Data produced: (COURTESY angularcode.com)

    SELECT status, COUNT(status) AS total


    FROM Repairs
    WHERE month(repairDate) = EXTRACT(month FROM (NOW()))
    GROUP BY
    ORDER BY repairDate DESC;

    Location: piechart.php

    Created a ‘MySQL View’ to display the piechart using google’s Chart module
    INSERT
    INSERT INTO staff (forename, surname, username, password, email, town, county, tel)
    VALUES ('$forename', '$surname', '$username', '$password', '$email', '$town', '$county',
    '$tel')

    Location: addNewStaff.php
    DELETE
    DELETE from stock WHERE stock_id = $stockid

    Location: delete/inventoryDelete.php

    UPDATE
    "UPDATE customers SET surname ='$ud_name', forename ='$ud_forename', town =
    '$ud_town', county = '$ud_county', tel = '$ud_tel' WHERE cust_id=$ud_id";

    Location: update/customerUpdated.php

    PROCESS
    products.php
    displayproducts.php
    mycart.php
    order.php
    neworder.php

    PERSONAL INFORMATION
    1. Last name
    2. First name
    3. Father’s name
    4. Mother’s name
    5. Gender
    6. DOB
    7. Cast
    8. Sub cast
    9. Nationality
    10. Religion
    11. Marital status

    GUARDIAN INFORMATION
    1. Last name
    2. First name
    3. Father’s name
    4. Mother’s name
    5. Gender
    6. Occupation
    7. Annual Income
    8. Contact number
    CONTACT INFORMATION
    1. Address
    2. Select country
    3. State
    4. District
    5. City
    6. Pin code
    7. Phone Number
    8. Mobile number
    9. Primary Email
    10. Retype Email

    Instructions for Registration for CET 2019

    1. Aspiring candidates can download CET information brochure from website for
    details.
    2. It is mandatory for the aspirsing candidates to download the application form
    through the candidate login by himself / herself on website.
    3. Application form should be submitted in college within the given registration
    period.
    4. Rs.1000/- exam fees should be submitted while admission form submission.
    5. The CET will be comprised of four sections viz. Mathematics and Statistics,
    logic/Abstract
    reasoning, English comprehension and computer concept 200 marks, with composite
    time of 120 min duration.
    6. Note that the CET will have negative mark system. Each correct answer will carry 2
    marks. Each wrong answer will carry 0.5 negative marks. Unanswered questions will
    carry zero marks.
    7. It should be noted that every document is required to be submitted during the
    registration for CET. However candidate are advised to keep the necessary original
    documents ready for verification at the time of document submission.
    8. Aspiring candidate should note that, the assessed Test Sheet will not be disclosed
    to anyone.

    You might also like