(help)Use this business description to make an ERD. A grocery store wants to keep track of...
(help)Use this business description to make an ERD.
A grocery store wants to keep track of its departments and employees. For each department, the store wants to record a department ID, a name, and a location. For each employee, the store wants to record an ID, a first name, a last name, a start date, and a phone number. A department can have many employees. The store wants to be able to assign employees in more than one department. Part time employees can be assigned to work in different departments on different days of the week. In addition we need to reflect a management relationship. A department has no manager, but an employee can manage many other employees and an employee is always managed by another employee (the manager).
Homework Answers
Add Answer to:
(help)Use this business description to make an ERD.
A grocery store wants to keep track of...
Projects inc. is an engineering firm with approximately 50 employees A database is required to keep...
Projects inc. is an engineering firm with approximately 50 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, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...
Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.
Exercise 1: ERD Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. A department employs many employees, but each employee is employed by only one department. Some employees, known as "rovers," are not assigned to any department. A division operates many departments, but each department is operated by only one division. An employee may be assigned many projects, and a project-may have many employees assigned to it. A project must have at least one employee...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission:...
Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission: For the scenario below, draw a logical design draft on the paper, and then draw the design in the computer using PG Modeler software. After that, export the model to PNG photo. Submit to Brightspace a word file that has a photo of the draft design (on the paper) and the PNG photo that is produced from the PG modeler. Database scenario: Assume that...
(Please do not copy and paste from another question. I am new to this and need...
(Please do not copy and paste from another question. I
am new to this and need it to be simple)
Draw an ERD for a “Hospital” with many departments and employees
in each department. show things like (one to one, one to many, many
to many).
What attributes would you store regarding each
objects/class/data entities?
Thank you!
(Example)
FIGURE 4-10 An ERD for a bank with many branches Customer cust number-PK name bill address home phone office phone = Account...
you are required to develop a simple HR application for a small accounting firm that wishes...
you are required to develop a simple HR application for a small accounting firm that wishes to keep track of all the employees at the firm; storing details about their salary, phone numbers and Date of Birth. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe...
Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based...
Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based on everything listed below University Bookstore •University Bookstore has several branches throughout Bloomington, and employees may be assigned to work at any of the branches. •Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date. •A Manager runs a branch and is responsible for all operations at that branch....
create a Crows Foot ERD using specilization ERD
Problem 3. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This...
ERD Diagram Based solely on the description of library operations below (without making up any additional...
ERD Diagram Based solely on the description of library operations below (without making up any additional facts/requirements) design a data model that avoids update anomalies. You can use text to describe your model if you want. If so be clear as to what columns have primary and foreign keys, as well as what table a FK refers to. You can sketch it out on paper and scan it. You can use Visio. You can use some other tool if you...
Write a program to keep track of the inventory of grocery store. Write a test program...
Write a program to keep track of the inventory of grocery store. Write a test program that prompts the user to enter how many items of inventory the store has. After that enter item name, quantity and price of each item in three different arrays called Itemname, Quantity and Price. Than calculate the Total=Quantity*Price of items in store and FinalTotal of all the items and print in following exact format using array: Sample run of program: Enter number of items...
Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information...
Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...
Projects inc. is an engineering firm with approximately 50 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, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...
(Please do not copy and paste from another question. I
am new to this and need it to be simple)
Draw an ERD for a “Hospital” with many departments and employees
in each department. show things like (one to one, one to many, many
to many).
What attributes would you store regarding each
objects/class/data entities?
Thank you!
(Example)
FIGURE 4-10 An ERD for a bank with many branches Customer cust number-PK name bill address home phone office phone = Account...
Most questions answered within 3 hours.
-
a. What double precision floating point
number is represented by the following 64-bit binary? Show your...
asked 6 minutes ago -
Indicate whether the statement is true or false
(1-20).
1)A good time management plan will eliminate...
asked 34 minutes ago -
Which one of the following will occur when the internal rate of
return equals the required...
asked 1 hour ago -
The mean value of land and buildings per acre from a sample of
farms is $1800,...
asked 1 hour ago -
The Hotel Conneautis considering 3 the
following capital budgeting projects
The Hotel Conneaut has internal funind for...
asked 1 hour ago -
Which of the following is NOT a product of the first step in the
p-p chain...
asked 1 hour ago -
The chance that UPS will deliver a package to a customer within
X days is normally...
asked 1 hour ago -
3Cu(NO3)2(aq) + 2Al(s) ---> 3Cu(s) + 2Al(NO3)3(aq) if you
have 32 moles of aluminum, what is...
asked 1 hour ago -
Four 100 micro Farads capacitors are connected in parallel, the
equivalent capacitance of these four capacitors...
asked 1 hour ago -
What is the pH of a 3% solution of atropine sulfate knowing that
the molecular weight...
asked 1 hour ago -
A company has current assets of
$90,000 and its current ratio is 2.5. Assume that the...
asked 1 hour ago -
A firm should never accept a project if its acceptance would
lead to an increase in...
asked 1 hour ago