Refer to the given data example that a manager prepares about equipment tracking in his organization. Servers (2), laptops (2), data storage units (1), equipment power packs (4), responsible managers: James Woo and Lily Gupta What must this manager do to the data before it is considered structured data? Place the quantities before the equipment types Determine what the primary key is Ensure that the data is password-protected Organize the data into rows and columns

Refer to the given data example that a manager prepares about equipment tracking in his organization. Servers (2), laptops (2), data storage units (1), equipment power packs (4), responsible managers: James Woo and Lily Gupta What must this manager do to the data before it is considered structured data? Place the quantities before the equipment types Determine what the primary key is Ensure that the data is password-protected Organize the data into rows and columns

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter5: Advanced Data Modeling

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

For both consumers and organizations, identity theft, in which individuals steal personal information, continues to be a major concern. Consider the following scenario: you are the database administrator for a huge firm that has a massive database that is accessible via the Internet. Are there any safeguards you would put in place to prevent people from stealing personal information from a company database?
Identity theft, in which people steal other people's personal information, is still a big source of worry for both individuals and businesses. Let's pretend you're a database administrator for a large company with extensive online databases. What do you do? Are there any measures you'd take to prevent unauthorised access to a company's database?
In the article, “Google search test shows no progress in cyber safety: a year after breaches exposed, UKFast director reveals that unsecure databases still likely to pose biggest cyber threat to SME security,” database security is revealed as the most fundamental part of creating a database, and it is vital to protecting a company’s information assets from unauthorized access. In fact, SQL injections have surpassed almost all other security vulnerabilities in 2013. Although security policies are often implemented to protect data, information security remains every employee’s responsibility. Data in the wrong hands can have a major negative impact on a business, and security of the data ultimately falls on the creator of the database. In this discussion board post, discuss the concept of database security as it relates to the Bible. What mandates does God give us with respect to protection of property? What real world examples support these biblical truths?
Now, Garden Glory wants to expand its database applications beyond the recording of property services. The company still wants to maintain data on owners, properties, employees, and services, but it wants to include other data as well. Specifically, Garden Glory wants to track equipment, how it is used during services, and equipment repairs. In addition, employees need to be trained before they use certain equipment, and management wants to be able to determine who has obtained training on which equipment. With regard to properties, Garden Glory has determined that most of the properties it services are too large and complex to be described in one record. The company wants the database to allow for many subproperty descriptions of a property. Thus, a particular property might have subproperty descriptions such as Front Garden, Back Garden, Second-Level Courtyard, and so on. For better accounting to the customers, services are to be related to the subproperties rather than to the…
1.1. 1 As the newly named CISO for your company, make an organisational presentation, explainin depth what data security is and explain the three forms of data ownership and theirrespective responsibilities. 1.2. According to the scenario results, company owners are advised to have data securitypolicies in place. Discuss in depth the components of the Issue Specific Security Policy(ISSP) and relate the policy to the scenario.
Consider Case Study (2): World’s Trend Catalog Division. Case -2: World’s Trend Catalog Division World’s Trend is a mail order supplier of high-quality, fashionable clothing. Customers place orders by telephone, by mailing an order form included with each catalog, or via the Web site. When customer orders come in, the item master and the customer master files are both updated. If an item is out of stock, the inventory control department is notified. If the order is from a new customer, a new record is created in the customer master file. Picking slips are produced for the customer order and sent to the warehouse. A shipping statement is prepared. The process of shipping a customer order involves getting the goods from the warehouse and matching up the customer shipping statement, getting the correct customer address, and shipping it all to the customer. The customer statement is generated, and a billing statement is sent to a customer once a month. An accounts receivable report is sent…
1.1. As the newly named CISO for your company, make an organisational presentation, explainin depth what data security is and explain the three forms of data ownership and theirrespective responsibilities.
A: Make a list of 5 internal data (specific data points such as “first name” and “sales per day”) that the following companies would have in their database: Amazon.ca, Pharmaprix, and Concordia University. (different ones for each. They should not be ordinary ones, i.e. first name and last name!). B: For each one, write a brief logic that why you think it could be a useful one. i.e. for birth date, you can say they might use it to congrats and provide coupons. Hint: Name and sales per day are the two examples of distinct information, which a company might have in its internal database. Another piece of information might be, for example, email address, gender, price trends, and so on. I am asking for a list containing 5 of such information - not real or mock examples: i.e. John, $20, etc - for each of the four companies. This information could be stored by different methods, i.e. when you sign up or purchase products from Amazon, you provide Amazon several different kinds of…
Explain and contrast differences and similarities between the DBA and DA. Explain how the DBA plays an arbitration role between an organization’s two main assets. Draw a diagram to illustrate your explanation. What are the DBA’s managerial roles? Describe the managerial activities and services provided by the DBA. What DBA activities support end users? Explain the DBA’s managerial role in the definition and enforcement of policies, procedures, and standards. Protecting data security, privacy, and integrity are important database functions. What activities are required in the DBA’s managerial role of enforcing those functions? Discuss the importance and characteristics of database backup and recovery procedures. Then describe the actions that must be detailed in backup and recovery plans. Assume that your company has assigned you the responsibility of selecting the corporate DBMS. Develop a checklist of the technical issues and other aspects involved…
Banking Database Schema:branch ( branch_name, branch_city, assets )customer ( cust_ID, customer_name, customer_street, customer_city )loan ( loan_number, branch_name, amount )borrower ( cust_ID, loan_number )account ( account_number, branch_name, balance )depositor ( cust_ID, account_number ) a) What are the appropriate primary keys? Indicate the appropriate primary keys by copying-and-pasting the above schema and underlining the primary key attributes.b. Given your choice of primary keys, identify appropriate foreign keys (i.e. identify attributes in referencing and referenced relations). You can state the foreign key constraints in words. For example, “For loan relation: branch_name attribute referencing branch relation.”c. Construct a relational database schema diagram for the bank database given above. Include a picture/illustration of your relational database schema diagram
Three agencies with databases that presumably include information about you are the Internal Revenue Service of the United States, your state's Bureau of Motor Vehicles, and the consumer reporting firm Equifax (see chart below). Explore each of these organisations' websites to find out the answers to the questions posed in the next section. What method is used to collect the information included in each database? Is it feasible for you to obtain a printout of the contents of your data record from each database that you use on a regular basis? Is it feasible for you to make changes to your data record if you discover an error? What privacy concerns do you have about the way these databases are handled in terms of data privacy?
Do databases need ethical considerations? Employee income and benefits data may not belong in the same database management system (DBMS) as sensitive personal data (such as medical information).

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS