BIS1002 Data Information Management & Reline Engineering - IT Assignment Help

Assignment Task

Reline Engineering    

Reline Engineering is an engineering firm with approximately 600 employees. A database is required to keep track of all employees, their skills, projects assigned, and departments worked in. Every employee has a unique number assigned by the firm and is required to store his or her name and date of birth. If an employee is currently married to another employee of Reline Engineering., the date of marriage and who is married to whom must be stored; however, no record of marriage is required if an employee’s spouse is not also an employee. Each employee is given a job title (e.g., engineer, secretary, and so on). An employee does only one type of job at any given time, and we only need to retain information for an employee’s current job. There are 10 different departments, each with a unique name. An employee can report to only 1 department. Each department has a phone number.To procure various kinds of equipment, each department deals with many vendors. A vendor typically supplies equipment to many departments. We are required to store the name and address of each vendor and the date of the last meeting between a department and a vendor. Many employees can work on a project. An employee can work on many projects (Project A, Project B etc.), but he/she can only be assigned to at most one project in a given city. For each city, we are interested in its state and population. An employee can have many skills (preparing material requisitions, checking drawings, and so on), but she or he may use only a given set of skills on a particular project. (For example, an employee WILLIAMS may prepare requisitions for the Project D and prepare requisitions as well as check drawings for Project E.) Employees use each skill that they possess in at least one project. Each skill is assigned a number, and we must store a short description of each skill.

Projects are distinguished by project numbers, and we must store the estimated cost of each project.
Your assignment consists of two parts.
Part 1. Conceptual Model

• Identify Entities
• Identify entity supertypes and subtypes and their types, inheritance.

discriminators.

•  Describe relationships between entities and their cardinalities
•  Identify entity primary keys
•  Draw a Conceptual Model Entity-Relationship diagram.

Part 2. Logical Model

•  Describe data attributes and their types for each entity
•  Redesign the Conceptual model removing many-to-many relationships (if any)
•  Identify primary, composite (if any) and foreign keys (if any) for each entity
•  if there are any one-to-one relationships then describe them
•  Draw a Logical Model diagram

This BIS1002 IT Assignment has been solved by our IT Experts at Exam Question Bank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction