Bountiful Contract Jobs (BCG) is a recently incorporated job placement agency that specializes in hiring staff...

  

Transcribed Image Text:

Bountiful Contract Jobs (BCG) is a recently incorporated job placement agency that specializes in hiring staff for different projects. BCG operates in a niche market of hiring IT staff, to be placed in non full time, contractual IT projects from different companies. BCG has contacted you to create a conceptual model to represent the database requirements for its job placement operations. For your analysis, the BCG manager has given you the following description (see below) of its data representation / operational requirements. BCG hires many staff which are later contracted to a company to work on its projects. One of the staff will be a project leader, who will be managing a project. Multiple staff will also be assigned to work in the project, under the leadership of the project leader. Each staff would normally have multiple certifications, although it is possible for a staff to be a fresh graduate, who has not passed exams necessary to attain any certification. In addition, the BCG manager requests that you take into account the following details: a) b) c) d) Each CERTIFICATION record is uniquely identified by certificate name, and stores a certificate description, as well as the date the certification was attained by the staff. Each STAFF record is uniquely identified by staff id, and stores details like staff name, date of birth, email and telephone. A staff may or may not be managing a project. But if the staff is a project leader, he / she may manage at most one project at a time. Multiple staff can be assigned to work in a particular project, and one project can have many staff assigned to it. f) g) h) Multiple staff can be contracted to work for a company, however, at any point in time, a staff can be contracted to only 1 company Each COMPANY record is uniquely identified by company name, and stores details like address, telephone and contact person's name. Each company generates multiple projects and each project is generated by a single company. Given the above information, draw the crow's foot ERD EERD capturing the business requirements for BCG. You are to identify all entities, its attributes, state clearly the FKs & PKs, as well as the relationships, connectivities, cardinalities and optionalities. Bountiful Contract Jobs (BCG) is a recently incorporated job placement agency that specializes in hiring staff for different projects. BCG operates in a niche market of hiring IT staff, to be placed in non full time, contractual IT projects from different companies. BCG has contacted you to create a conceptual model to represent the database requirements for its job placement operations. For your analysis, the BCG manager has given you the following description (see below) of its data representation / operational requirements. BCG hires many staff which are later contracted to a company to work on its projects. One of the staff will be a project leader, who will be managing a project. Multiple staff will also be assigned to work in the project, under the leadership of the project leader. Each staff would normally have multiple certifications, although it is possible for a staff to be a fresh graduate, who has not passed exams necessary to attain any certification. In addition, the BCG manager requests that you take into account the following details: a) b) c) d) Each CERTIFICATION record is uniquely identified by certificate name, and stores a certificate description, as well as the date the certification was attained by the staff. Each STAFF record is uniquely identified by staff id, and stores details like staff name, date of birth, email and telephone. A staff may or may not be managing a project. But if the staff is a project leader, he / she may manage at most one project at a time. Multiple staff can be assigned to work in a particular project, and one project can have many staff assigned to it. f) g) h) Multiple staff can be contracted to work for a company, however, at any point in time, a staff can be contracted to only 1 company Each COMPANY record is uniquely identified by company name, and stores details like address, telephone and contact person's name. Each company generates multiple projects and each project is generated by a single company. Given the above information, draw the crow's foot ERD EERD capturing the business requirements for BCG. You are to identify all entities, its attributes, state clearly the FKs & PKs, as well as the relationships, connectivities, cardinalities and optionalities.

Answer rating: 100% (QA)

The image you sent shows a diagram of a social media data warehouse A data warehouse is a central repository for all of the data that a social media c... View the full answer