Question1.Use VISIO for the following business rules to create a Crow’s Foot ERD.•ABC Construction does custom construction projects.•Each project has a foreman and a customer.•Multiple projects can be done for the same customer over time.•Each foreman can run multiple projects over time.•When a project is started, the total time and cost is estimated.•Each project has multiple activities that are required to complete project work.•Each activity has an estimated start date, estimated end date, estimated cost, actual start date, actual end date, percent complete and actual cost.•Each week a progress report is created for a project.•Each progress report communicates the objectives completed, work planned for the next week, and lessons learned.•When a project is completed, the actual cost is recorded. It is calculated by adding the actual costs from all of the activities.•Each project is performed at a location owned by the customer.•Each customer can own multiple locations.Question 2.Use VISIO for the following business rules to create a Crow’s Foot ERD.•UNIVERSITY wants to track bus and facility usage using the RFID chips that are in students’ ID cards (this is a fictional scenario – the university is not actually doing this).•Each bus and facility is equipped with an RFID reader that reads a student’s ID number when a bus or facility is entered or exited.•Directional antennas are used to determine if the read is from an entry or exit.•Each bus is driven by a bus driver.•Bus drivers drive the buses according to a work schedule.•Buses make multiple stops, but they always visit the stops in the same order.•Administrators want to know aggregate information about entries by time by location, exits by time by location, and usage (in between entry and exit) by time by location.•Each bus driver has a personal vehicle that is authorized to park in the parking lot.•The bus driver’s vehicle is identified by a license plate number.
Use VISIO to create a Crow’s Foot ERD
A professional Academic Services Provider
Platinum Essays, We are Built on the Values of Reliability, Proffessionalism, and IntegrityWe are a Custom Academic Writing service provider with over a decade of extensive experience in the academic and business writing service industry. We are consistently engaged in advising students on the methodologies of coping with essay writing, term papers, thesis, dissertation and many other approaches towards handling assignments Our main goal is to help present a conceptual model of papers to our clients. Whether it is as a result of academic difficulties, Burnout during studies, or simply the need to have that extra time for your personal growth, what we are is an institution that only focuses on your Academic Growth. By presenting a paper worthy of turning in, we provide you with an excellent model that matches or supersedes your requirements. Our strong belief in academic integrity is held to the highest standards. As such, all papers are developed from scratch and run through software to gurantee authenticity (100 % PLAGIARISM FREE). The Papers are pre-marked by our tutors to ensure it matches the required marking schemes. On deliverly, the paper guarantees top grades and an improved GPA.
Our Core Values.
Process of Placing an Order