locked
sql assgnment RRS feed

  • Question

  • TeamWorks Inc. is one of the leading corporate training companies in Asia. The company is
    primarily involved in imparting corporate training to its offshore clients located in London, Australia,
    and China. Today, under the chairmanship of Lewis Lee, the company has spread across the
    world.
    The company maintains the details of its employees and clients in the Employee and Client files,
    respectively. In addition, the company maintains the details of various projects undertaken in the
    Project file. The details stored in the Employee file consist of employee ID, employee name,
    gender, phone number, department ID, department name, project ID, and project name. However,
    the details stored in the Client file consist of client ID, client name, project ID, and project name. In
    addition, the Project file consists of project ID, project name, employee ID, employee name,
    department ID, department name, project start date, project end date, and project cost.
    Due to the high quality of services it offers, the company has noticed a tremendous increase in the
    number of its offshore projects. Consequently, it has become very difficult for the company to
    manually maintain the details of various projects undertaken. Therefore, the company has decides
    to use an automated project management system. For this, the company approaches SoftTech
    Inc. to develop the automated project management system.
    At SoftTech Inc., a team of developers have been assigned the task to create the required
    application. Harry Butler, being the team leader, analyzes the application and identifies the various
    components required to create the application. Being the database developer in the team, you
    have been assigned the task to analyze the application and create the required database and
    tables.
    You need to analyze the various files in the given scenario and perform the following tasks:
    1. Identify the various entities that may cause data redundancy. Justify your answer. [5 Marks]
    2. Identify the various problems that may arise due to data redundancy. Justify your answer. [5
    Marks]
    Wednesday, May 6, 2015 5:36 AM

All replies

  • help me pls
    Wednesday, May 6, 2015 5:42 AM
  • Hello,

    What help you want from us? Since this is sharepoint forum so you also have to clear, which product  (SQL OR sharepoint) you are using to complete this task.


    Hemendra:Yesterday is just a memory,Tomorrow we may never see<br/> Please remember to mark the replies as answers if they help and unmark them if they provide no help

    Wednesday, May 6, 2015 6:05 AM
    Moderator
  • what help are you seeking ? are you sure this is not spam?
    Wednesday, May 27, 2015 2:04 AM