You are asked to design a database to support a Instant Recruitment System of casual staff...

You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram and the accompanying document should identify keys, constraints, entity types, relationship types, specialisation/generalisation if any, etc. You must use the same notation scheme for the ER diagram as the textbook (use UML notations as shown in the last page of the textbook, and don't use Crew Foot notations), and the ER diagram should be strictly in the way the textbook uses for.

The ER diagram should include, among others, representative attributes for all entity types, proper subclassing if any, and correct participation multiplicities for the relationship types. It should be meaningfully and well designed, and should also include all relevant and necessary aspects, and indicate any supplementary business rules if you decide to introduce.
Map the above ER diagram into a global relation diagram (GRD) All the attributes should be kept there too. Include in the diagram all the primary keys, foreign keys, and the multiplicity constraints. (
Please note that an ERD is the artefact of the conceptual database design phase, while a GRD is the artfact of the logical database design phase which relates to the relational models. As such, a good ERD should be conceptually more concise and the relationships there should in general remain so rather than becoming extra entities as in a relational model.

Expert Solution

venereology answered 2 days ago

Database You have just started a new position on the database design staff at Gizmonic Consultants,...

Database You have just started a new position on the database design staff at Gizmonic Consultants, Inc. Your first project is to translate the database requirements for Continental Hotels into an ER representation. In the next project, you will derive a relational schema from an ER diagram and implement the schema, populate it, and query over it. Requirements: Develop an ERD to capture the entities and relationships specified in the requirements documentation below. Use only the conventions covered in class....

You are asked to design a relational database for a simple course registration software application for...

You are asked to design a relational database for a simple course registration software application for your school. The relational database must have the following information about the student, the course, and the registration, respectively StudentID, FirstName, LastName, DataOfJoining, and Major CourseNumber, CourseName,InstructorName, StartDate, EndDate, NumberOfCredits ReferenceID, StudentID,CourseID, DateOfRegistration Apply the following constrains while designing the database Each student in the database must be uniquely identifiable Each course listed in the database must be have unique CourseNumber Each course registration...

You have been tasked to design a database to support your new business. This business could...

You have been tasked to design a database to support your new business. This business could be one of many possibilities such as a car dealership, Internet Sales, Graphic Design, Fitness counselor or anything you can imagine. Describe the entities and their attributes that might be required for this application, the type of database processing required, and the application software needed. Pick something unique for you. Note: this doesn't have to be complex. A few entities and attributes will suffice....

Assume you are creating a database for IS paint store. The database needs to support the...

Assume you are creating a database for IS paint store. The database needs to support the following business functions. • Allow customers to browse the inventory. Customers want to search by paint types and colors. Customers also wants to know pricing information. • A customer can be a regular customer (e.g., home owner), or a contractor or painting professionals. Different customers can get different discounts for the same type of paint. We assume each customer can get the same discount...

In regards to modern operating systems If you are asked to design a hotel check-in system...

In regards to modern operating systems If you are asked to design a hotel check-in system that has three steps, what would you like to propose? If you are asked to detail your previous design so that it has five steps, how would you update it and why? If you are asked to propose a hotel check-in system without any limitation in steps, what would it be and why?

You are asked to design a piping system to fill an Olympic size swimming pool. The...

You are asked to design a piping system to fill an Olympic size swimming pool. The nominal dimensions of the pool are 164 ft long, 82 ft wide and 6 ft deep, and the filling is to take place in 6 hours. The 60 F water supply is contained in a reservoir 75 ft below the nominal elevation of the pool and contains 500 feet of 6-inch diameter cast iron pipe with 4 standard 90° elbows and 1 (fully open)...

The Case of Bridgeport Academy of a new performance management system designed specifically for support staff...

The Case of Bridgeport Academy of a new performance management system designed specifically for support staff at a school in the United Kingdom. Background • This fictionalized case study is based on a real organization. The school is a public, mixed comprehensive secondary school located in the United Kingdom with an average annual turnover in excess of £1 million. Because it is government funded, it is a non-profit organization. • Although the case study is in a school setting, many...

A boarding school in your area has asked you to design a simple system so that...

A boarding school in your area has asked you to design a simple system so that they could easily identify the students who are staying in the hostel rooms as well as the wardens who are in charge of each student blocks. Each staff may be in charge of guarding a hostel block. This is not permanent because after certain duration the staff will change blocks. The guarding duty is rotational and not all the staff are required to do...

You have been asked to design an elevator system. The functions of an elevator includes moving...

You have been asked to design an elevator system. The functions of an elevator includes moving up and down, open and close doors, and pick up passengers. The elevator is supposed to be used in a building having floors numbered from 1 to MaxFloor, where the first floor is the lobby. There are car call buttons in the car corresponding to each floor. For every floor except for the top floor and the lobby, there are two hall call buttons...

The owner of Horne Design Wallcoverings has hired you as a consultant to design a database...

The owner of Horne Design Wallcoverings has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers and employees. After initial meeting with him, you have developed a list of business rules and specifications to begin the design of an E-R Model. The list of business rules are: Customers place orders through a branch A customer may place many orders A...

Question