(a) ERD
Please find below the steps to create ERD:
Step 1: List the entities:
Step 2: List the relationship between the entities:
Step 3: Create the ERD as per given instruction:
(b) ERD attributes:
Let’s assign the attributes to entity as per given instruction:
Plant
Composite attribute: PlantLocation (StreetAddress, City, State, Zipcode)
Multivalued Attribute: Facilities(Multiple facilities that are given in plant)
Other Attribute(s): PlanName
Department
Composite attribute: WorkHandled(WorkType , WorkName)
Multivalued Attribute: Functions(Multiple functions that are performed in the department)
Other Attribute(s): Description
Workstation
Composite attribute: Location(StreetNo, City, State, Zipcode)
Multivalued Attribute: ContactPhone(Multiple numbers)
Other Attribute(s): StationName
Employee
Composite attribute: Name(FirstName, LastName)
Multivalued Attribute: PhoneNumber
Other Attribute(s): Email
Jobtypes
Composite attribute: Type(Primary, Secondary)
Multivalued Attribute: SkillRequired
Other Attribute(s): Description
Job Task
Composite attribute: TaskToBeDone(Task1, Task2, Task3)
Multivalued Attribute: SkillsRequired
Other Attribute(s): TaskName
WorkUnion
Composite attribute: Location(Street, City, State, ZipCode)
Multivalued Attribute: Specialities
Other Attribute(s): Description
(c) ERD with attributes:
Please find below the primary key for all the entities:
Updated ERD with attributes added in it:
ERD Notations:
5.A lawn and tree care company RealGreen uses the paper form as below to record the weekly (just one week in this question!) information about its part-time employees (one form for one employee). The company asks you to create a database application to keep track of the information of the part-time employees. Please (a) develop the E-R diagram (8 points). (b) develop the table structures. Each table should include table name, attributes, and the primary key (6 points). Employee ID:...
QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...
QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...
Considering the following E-R diagram, your task is to create a script file for defining relations and populating data, you can use any text editor (notepad/notepad+) to write SQL statements and save it with the file extension.sql (i.e., Test3Tsay.sql). Name the file as Test3XXX.sql (where XXX is your last name). Upload it to here. endedDate phone startedDate name address name location no salary no Employees Projects assignDate P WorksOn Scientists Technicians research hEduDegree N certifications Equipments cost no Task 1...
Question 4 Needs Grading Q1) (2.5 Points ) We would like to design a database to keep track of a zoo. The following describes the business of the zoo: • The zoo employees are known as zookeepers. Each zookeeper has a name, a unique employee ID number, and a salary. Zookeepers may work in any number of exhibits but they have to be involved in at least one exhibit. A zookeeper does not have to work in an exhibit to...
1. Please answer the following questions. You need to draw ER diagrams using any free tools discussed in the class or you may draw using pencil and paper. Please identify the entities and relationships between them. For each entity, please identify the attributes each entity has. For each attribute, please identify whether this attribute is optional or required, single valued or multi-valued, simple or composite, stored or derived. Define a key (identifier) for each entity. Note that a key can...
6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database problem found in the news: Rental-owner database seen as solution to problem properties. A municipality (city) is creating a new database to help manage problems with rental properties within the city. They need to keep track of basic information (description, address, etc.)on the properties being rented within the city. They will store information on two types of rental properties, houses and apartments. These have...
New to DB's Please help! You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id). Professors teach courses. Each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it (assuming no further constraints hold). a) Professors can teach the same course in several semesters, and each offering must be recorded. b) Professors can teach the same course in several semesters, and only the most recent such offering needs to be...