Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
esign a RELATIONAL SCHEMA not an ERD for the pllowing A job-shop accounting system is part of an organization that manufactures special-purpose assemblies for customers. A customer has a unique name, an address, and a category (an integer number from 1-10). A customer can order several assemblies. Each assembly is identified by a unique assembly-id, and has a date-ordered, and assembly-details. To manufacture assemblies, the organization contains a number of processes, each of which is identified by a unique process-id and is supervised by one department. Each department has its own department number and department-data. Each process also has process-data. Processes are classified into three types: paint, fit, and cut. The following information is kept about each type of process: Fit: fit-type Paint: paint-type, painting-method Cut: cutting-type, machine-type During manufacture an assembly can pass through any sequence of processes in any order; it may pass through the same process more than once. A job is assigned every time a process begins on an assembly. Information recorded about a job includes a unique job-no, a date the job commenced, and a date the job completed as well as additional information that depends on the type of job. Jobs are classified into three job types: cut- job, paint-job, and fit-job. Information stored about particular job types is: Cut-job: type of machine used, amount of time the machine used, material used, and labor time. Pain-job: color, volume, and labor time. Fit-job: labor time. An account is maintained by the organization to keep track of expenditures for each process, each assembly, and each department. For each account, the database stores its unique account number and the date the account established. Three types of accounts are maintained: Assembly-account to record costs (details-1) for assemblies. Department-account to record costs (details-2) for departments. Process-account to record costs (details-3) for processes. As a job proceeds, cost transactions can be recorded against it. Each such transaction is identified by a unique transaction number and is for a given cost (sup-cost). Each transaction updates three accounts: A process account An assembly account A department account The updated process account is for the process used by a job. The updated department account is for the department that manages that process. The updated assembly account is for the

esign a RELATIONAL SCHEMA not an ERD for the pllowing A job-shop accounting system is part of an organization that manufactures special-purpose assemblies for customers. A customer has a unique name, an address, and a category (an integer number from 1-10). A customer can order several assemblies. Each assembly is identified by a unique assembly-id, and has a date-ordered, and assembly-details. To manufacture assemblies, the organization contains a number of processes, each of which is identified by a unique process-id and is supervised by one department. Each department has its own department number and department-data. Each process also has process-data. Processes are classified into three types: paint, fit, and cut. The following information is kept about each type of process: Fit: fit-type Paint: paint-type, painting-method Cut: cutting-type, machine-type During manufacture an assembly can pass through any sequence of processes in any order; it may pass through the same process more than once. A job is assigned every time a process begins on an assembly. Information recorded about a job includes a unique job-no, a date the job commenced, and a date the job completed as well as additional information that depends on the type of job. Jobs are classified into three job types: cut- job, paint-job, and fit-job. Information stored about particular job types is: Cut-job: type of machine used, amount of time the machine used, material used, and labor time. Pain-job: color, volume, and labor time. Fit-job: labor time. An account is maintained by the organization to keep track of expenditures for each process, each assembly, and each department. For each account, the database stores its unique account number and the date the account established. Three types of accounts are maintained: Assembly-account to record costs (details-1) for assemblies. Department-account to record costs (details-2) for departments. Process-account to record costs (details-3) for processes. As a job proceeds, cost transactions can be recorded against it. Each such transaction is identified by a unique transaction number and is for a given cost (sup-cost). Each transaction updates three accounts: A process account An assembly account A department account The updated process account is for the process used by a job. The updated department account is for the department that manages that process. The updated assembly account is for the

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Computer Science design a RELATIONAL SCHEMA not an ERD for the following A job-shop accounting system is part of an organization that manufactures special-purpose assemblies for customers. A customer has a unique name, an address, and a category (an integer number from 1-10). A customer can order several assemblies. Each assembly is identified by a unique assembly-id, and has a date-ordered, and assembly-details. To manufacture assemblies, the organization contains a number of processes, each of which is identified by a unique process-id and is supervised by one department. Each department has its own department number and department-data. Each process also has process-data. Processes are classified into three types: paint, fit, and cut. The following information is kept about each type of process: Fit: fit-type Paint: paint-type, painting-method • Cut: cutting-type, machine-type During manufacture an assembly can pass through any sequence of processes in any order; it may pass through the same process more than once. A job is assigned every time a process begins on an assembly. Information recorded about a job includes a unique job-no, a date the job commenced, and a date the job completed as well as additional information that depends on the type of job. Jobs are classified into three job types: cut- job, paint-job, and fit-job. Information stored about particular job types is: Cut-job: type of machine used, amount of time the machine used, material used, and labor time. Pain-job: color, volume, and labor time. Fit-job: labor time. An account is maintained by the organization to keep track of expenditures for each process, each assembly, and each department. For each account, the database stores its unique account number and the date the account established. Three types of accounts are maintained: Assembly-account to record costs (details-1) for assemblies. Department-account to record costs (details-2) for departments. Process-account to record costs (details-3) for processes. As a job proceeds, cost transactions can be recorded against it. Each such transaction is identified by a unique transaction number and is for a given cost (sup-cost). Each transaction updates three accounts: A process account An assembly account A department account The updated process account is for the process used by a job. The updated department account is for the department that manages that process. The updated assembly account is for the assembly that requires the job.
Transcribed Image Text:Computer Science design a RELATIONAL SCHEMA not an ERD for the following A job-shop accounting system is part of an organization that manufactures special-purpose assemblies for customers. A customer has a unique name, an address, and a category (an integer number from 1-10). A customer can order several assemblies. Each assembly is identified by a unique assembly-id, and has a date-ordered, and assembly-details. To manufacture assemblies, the organization contains a number of processes, each of which is identified by a unique process-id and is supervised by one department. Each department has its own department number and department-data. Each process also has process-data. Processes are classified into three types: paint, fit, and cut. The following information is kept about each type of process: Fit: fit-type Paint: paint-type, painting-method • Cut: cutting-type, machine-type During manufacture an assembly can pass through any sequence of processes in any order; it may pass through the same process more than once. A job is assigned every time a process begins on an assembly. Information recorded about a job includes a unique job-no, a date the job commenced, and a date the job completed as well as additional information that depends on the type of job. Jobs are classified into three job types: cut- job, paint-job, and fit-job. Information stored about particular job types is: Cut-job: type of machine used, amount of time the machine used, material used, and labor time. Pain-job: color, volume, and labor time. Fit-job: labor time. An account is maintained by the organization to keep track of expenditures for each process, each assembly, and each department. For each account, the database stores its unique account number and the date the account established. Three types of accounts are maintained: Assembly-account to record costs (details-1) for assemblies. Department-account to record costs (details-2) for departments. Process-account to record costs (details-3) for processes. As a job proceeds, cost transactions can be recorded against it. Each such transaction is identified by a unique transaction number and is for a given cost (sup-cost). Each transaction updates three accounts: A process account An assembly account A department account The updated process account is for the process used by a job. The updated department account is for the department that manages that process. The updated assembly account is for the assembly that requires the job.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS