You want to create a database for computer lab management. You want to keep track of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You want to create a database for computer lab management. You want to keep track of the following information (Type your answer): The information about computer/workstation such as station ID, model, etc. The information about the software installed. Each computer station has various types of software (e.g., word processor, spreadsheet, database, diagramming tools, etc.) Note you only care about the types, version and vendors of the software, not the licensing information of each piece of software. You just want to know which type of the software is used most frequently. The information about projects that are running on some computer station. Including the project ID, description, project leader and starting date, etc. The information about users who are the employees currently working some projects. Including employee's ID and name, as well as job title. The information about appointments made by users to use the lab. A user needs to make an appointment to use a workstation. For an appointment, employee need to indicate (or assigned) a station ID, indicating types of software to use, and the time period of using the station. Note: In each appointment, an employee can only indicate one computer with multiple software to use. a. Design an E/R diagram to model above situation. b. Convert the data model in (a) into tables, clearly indicate the keys and foreign keys. You want to create a database for computer lab management. You want to keep track of the following information (Type your answer): The information about computer/workstation such as station ID, model, etc. The information about the software installed. Each computer station has various types of software (e.g., word processor, spreadsheet, database, diagramming tools, etc.) Note you only care about the types, version and vendors of the software, not the licensing information of each piece of software. You just want to know which type of the software is used most frequently. The information about projects that are running on some computer station. Including the project ID, description, project leader and starting date, etc. The information about users who are the employees currently working some projects. Including employee's ID and name, as well as job title. The information about appointments made by users to use the lab. A user needs to make an appointment to use a workstation. For an appointment, employee need to indicate (or assigned) a station ID, indicating types of software to use, and the time period of using the station. Note: In each appointment, an employee can only indicate one computer with multiple software to use. a. Design an E/R diagram to model above situation. b. Convert the data model in (a) into tables, clearly indicate the keys and foreign keys.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
PRO-FORMS, INC. J.B. Bryson (-Br to everyone who knew her). General Manager of Pro-Forms. Inc., read the invitation with interest: You are invited to attend a retirement party for Iris David...." Was...
-
Read the article Job Design, Job Characteristics, and Job Crafting and write a paper about it
-
Given are five observations for two variables, x and y. a. Develop a scatter diagram for these data. b. What does the scatter diagram developed in part (a) indicate about the relationship between the...
-
Examine the a fashion retail service blueprint process carefully and discuss problems that have ensued in the organisation that are echoed in the blueprint but do not add value to the customer.
-
Organizational communication has both formal and informal dimensions. In traditional organizations, most messages that need to be communicated must go through the chain of command. In other words,...
-
What is the condition for maximum power transmission by a belt?
-
Which of the following situations would most likely require special audit planning by the auditor? a. Some items of factory equipment do not bear identification numbers. b. Depreciation methods used...
-
What are the three different types of qualified audit opinion? Discuss the circumstances that may cause these qualifications.
-
The objective of performing analytical procedures in planning an audit is to identify the existence of a. Unusual transactions and events. b. Illegal acts that went undetected because of internal...
-
When planning an audit, the auditor needs to evaluate audit risk where the auditor may unknowingly fail to appropriately modify his or her opinion on financial statements that are materially...
Study smarter with the SolutionInn App