MARCIAS DRY CLEANING CASE QUESTIONS Ms. Marcia Wilson owns and operates Marcias
ID: 646594 • Letter: M
Question
MARCIAS DRY CLEANING CASE QUESTIONS
Ms. Marcia Wilson owns and operates Marcias Dry Cleaning, which is an upscale dry cleaner in a well-to-do suburban neighborhood. Marcia makes her business stand out from the competition by providing superior customer service. She wants to keep track of each of her customers and their orders. Ultimately, she wants to notify them that their clothes are ready via email.
Assume that Marcia has hired you as a database consultant to develop an operational database having the following four tables:
CUSTOMER (CustomerID, FirstName, LastName, Phone, Email)
INVOICE (InvoiceNumber, CustomerID, DateIn, DateOut, Subtotal, Tax, TotalAmount)
INVOICE_ITEM (InvoiceNumber, ItemNumber, ServiceID, Quantity, UnitPrice,
ExtendedPrice)
SERVICE (ServiceID, ServiceDescription, UnitPrice)
A. Assume that Marcias Dry Cleaning has the following personnel: two owners, a shift manager, a part-time seamstress, and two salesclerks. Prepare a two-to-three-page memo that addresses the following points:
1. The need for database administration.
2. Your recommendation as to who should serve as database administrator. Assume that Marcias Dry Cleaning is not sufficiently large to need or afford a full-time database administrator.
3. Using the main topics in this chapter as a guide, write a job description describing the nature of database administration activities at Marcias Dry Cleaning. As an aggressive consultant, keep in mind that you can recommend yourself for performing some of the DBA functions.
B. For the employees described in part A, define users, groups, and permissions on data in these four tables. Use the security scheme shown in Figure 6-15 as an example. Create a table like that in Figure 6-16. Dont forget to include yourself.
Explanation / Answer
A:
1: The need of database administration :
Database is collection of data which is most vital part of any industry whether it is IT industry or manufacturing or any type of industry and most challenging part is to store and maintain that data effectively. Every industry need some man power to operate Data management software present in today’s life. Here Data administration comes in to picture,
Database administration is function of managing and maintaining database management system. Software(DBMS).
Performance is main issue behind database administration. Because in earlier times we use file systems to handle data and it requires lots of manpower and time. Updating or deleting data from these file systems require lot of headache. To overcome all these challenges DBMS comes in to picture.
Database management system in software to maintain data using software like Mysql,oracle and you know that if there is software then there is need of someone who can operate on it. Thus database administrator comes in to picture.
Without database administration you will waste time and resources and result in to poor performance of system and affect productivity of business. Without database administration you will end up in to invalid data and data redundancy which wastes your memory and performance. Data Administration focus on your requirements like installing and upgrading database, taking care of database design ,implementing data security etc . All these operation comes under database administration.
2: As you have mention Marcia’s Dry Cleaning is not sufficiently large to need or afford a full-time database administrator So for administrating database one of the “salesclerks” can do the work of database administrator after having proper training and knowledge.
3: Job description
As a database administrator, you wil be responsible for the performance and security of a database. Depending on the organisation and your level of responsibility, the role can vary from inputting information to database to database design and architecture.
Depending on your level of responsibility, typical tasks may include:
• Assisting in database design
• Database recovery
• Updating and deleting existing databases
• Setting up and testing new database and data handling systems
• Monitoring database efficiency
• Maintain the security and integrity of data
• Troubleshooting
• Creating complex query definitions that allow data to be extracted
• Training colleagues in how to input and extract data
• Take care of the database design and implementation.
• Maintain documentation
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.