Scribd Logo
Upload

Welcome to Scribd!

  • 93 views

    Database Lab#03

    Uploaded by

    Abdur Rahman
    The document describes two lab tasks involving creating entity relationship diagrams (ERDs). The first task involves entities such as departments, projects, employees, and their relationships. The second task involves entities like candidates, job qualifications, companies requesting temporaries, temporary job openings, and placement records. The ERDs will model the relationships between these entities based on the given requirements.

    Copyright:

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

    Database Lab#03

    Uploaded by

    Abdur Rahman
    93 views4 pages
    The document describes two lab tasks involving creating entity relationship diagrams (ERDs). The first task involves entities such as departments, projects, employees, and their relationships. The second task involves entities like candidates, job qualifications, companies requesting temporaries, temporary job openings, and placement records. The ERDs will model the relationships between these entities based on the given requirements.

    Original Title

    Database lab#03

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes two lab tasks involving creating entity relationship diagrams (ERDs). The first task involves entities such as departments, projects, employees, and their relationships. The second task involves entities like candidates, job qualifications, companies requesting temporaries, temporary job openings, and placement records. The ERDs will model the relationships between these entities based on the given requirements.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    93 views4 pages

    Database Lab#03

    Uploaded by

    Abdur Rahman
    The document describes two lab tasks involving creating entity relationship diagrams (ERDs). The first task involves entities such as departments, projects, employees, and their relationships. The second task involves entities like candidates, job qualifications, companies requesting temporaries, temporary job openings, and placement records. The ERDs will model the relationships between these entities based on the given requirements.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    Lab#03

    To make students familiar with different notations for relationships


    among entities

    Name; Usman ali


    E/ID; 783
    Sub; Database lab
    Semester 4th
    Deptt; software engineering
    Submitted to; Engr Zeeshan Danish
    Lab # 3.1
    Draw Entity Relationship Diagram for the following requirements.

    Lab Task 1: The Company is organized into departments. Each department has a unique name, a unique
    number, and a particular employee who manages the department. We keep track of the start date when
    that employee began managing the department. A department may have several locations.

     A department controls a number of projects, each of which has a unique name, a unique number, and
    a single location.

     The database will store each employee’s name, CNIC, address, salary, sex (gender), and birth date. An
    employee is assigned to one department, but may work on several projects, which are not necessarily
    controlled by the same department. It is required to keep track of the current number of hours per week
    that an employee works on each project, as well as the direct supervisor of each employee.
    Lab#3.2
    : During peak periods, Temporary Employment Corporation (TEC) places temporary workers in
    companies. TEC’s manager gives you the following description of the business

     TEC has a file of candidates who are willing to work.

     If the candidate has worked before, that candidate has a specific job history. (Naturally, no job history
    exists if the candidate has never worked.) Each time the candidate works, one additional job history
    record is created.

     Each candidate has earned several qualifications. Each qualification may be earned by more than one
    candidate. (For example, it is possible for more than one candidate to have earned a BBA degree or a
    Microsoft Network Certification. And clearly, a candidate may have earned both a BBA and a Microsoft
    Network Certification.)

     TEC also has a list of companies that request temporaries.

     Each time a company requests a temporary employee, TEC makes an entry in the Openings folder.
    That folder contains an opening number, a company name, required qualifications, a starting date, an
    anticipated ending date, and hourly pay.

     Each opening requires only one specific or main qualification.

     When a candidate matches the qualification, the job is assigned and an entry is made in the Placement
    Record folder. That folder contains an opening number, a candidate number, the total hours worked,
    etc. In addition, an entry is made in the job history for the candidate.

     An opening can be filed by many candidates, and a candidate can fill many openings

    You might also like