CRUD

CRUD

Part 1:

Please respond to the following in not more than 250 words:

• Identify a database table in a specific business system, and one user (not administrator) role that might need access to that table. Do not repeat an example from the textbook or one that has been posted by another student.
• Which of the create, read, update, and delete (CRUD) rights would you grant to that role, and which would you withhold? Why?

Part 2:

In a separate post, follow up on one of your fellow students in substantive posts of up to 200 words that further the discussion. For example, you may support or politely challenge a post with your own insights or experience, make a suggestion, or ask probing follow-up questions.

Support your positions with explanations and/or sources, as appropriate, but do not quote. (choose one)

a. A simple database program has tables that are separate entries you can make to the program.  Databases have become very useful way to have computer-based systems to take over from paper-based system. The ability to assign privileges to individual tables allows you to setup security to the systems information. The searchability of this information has transformed the way we store and recall information. We use a web-based customer database at work to assign ticket numbers, serial numbers of equipment and problem descriptions.  All notes about repairs are added along with parts and labor.  All workers have create, read, update privileges, only managers can delete charges or modify prices.  They have set this up that way to keep techs from modifying prices and making unauthorized changes to work orders.  Say a worker’s friend comes in for service and they want to give their friend a break by cutting prices and pocketing the cash.  Other examples would be just keeping us out of trouble I like not having these privileges that way I am not responsible for these situations.   

b.  The database table from a specific business system would be from a used car department in a dealership. The table would contain information on cars that where traded in and the money recieved from that traded in car. Also the table would contain numbers on market value of the car and wholesale value from the car. The user that would need access to that table would be the used car manager. He is the one that needs the create, read and update rights. The only right he should not have is the delete rights, that should be higher in the food chain. 

c.  A clothing store would need a database that records inventory, sales, and returns. The store managers would need access to the database to view sales and make adjustments as needed. I would grant the store manager the read and update roles, and I would grant other store personnel read permissions. 

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order