Chapter 7, Problem 2HOA

Differentiate between VIEW and COPY?

Write the command to delete a user: tom  Write the command to change the password of a user: tom

Correct command perform:-

Why are access restrictions needed today? Please list two access restrictions.

Select the information that cannot be changed after a company file is created in MYOB:   names of accounts in the accounts list   the company's phone number   conversion month   all of the above options cannot be changed after creating the company file

SQL Injection is the term used to describe an attack against a SQL database.

User account2. The system allows user to register and create the account3. Users allowed by system to edit & modify the account4. System allows users to view products5. System allows users to comment on product6. Perform sentiment analysis7. Use APS to connect to product8. Review website to collect comment of product9. System dynamically analyze command of users10. Matching keyword in database11. system allots rank to product as good, bad and ugly12. view product review13. users can use system to view product14. manage users account15. all users account allowed to be added or modified , and deleted by administrator   Non Functional Requirements: 1.     Efficiency 2.     Interoperable 3.     Portability 4.     Security Part A: Answer the following questions prefer to the previous requirements? 1. Context Data Model: Show the entities with their relationships (as explained in the class)

User account2. The system allows user to register and create the account3. Users allowed by system to edit & modify the account4. System allows users to view products5. System allows users to comment on product6. Perform sentiment analysis7. Use APS to connect to product8. Review website to collect comment of product9. System dynamically analyze command of users10. Matching keyword in database11. system allots rank to product as good, bad and ugly12. view product review13. users can use system to view product14. manage users account15. all users account allowed to be added or modified , and deleted by administrator   Non Functional Requirements: 1.     Efficiency 2.     Interoperable 3.     Portability 4.     Security Prefer to the functional and non-functional requirements answer the question: Question : Full System Data Flow Diagram : (It shows the big picture of the system by merging all the event handlers.)

User account2. The system allows user to register and create the account3. Users allowed by system to edit & modify the account4. System allows users to view products5. System allows users to comment on product6. Perform sentiment analysis7. Use APS to connect to product8. Review website to collect comment of product9. System dynamically analyze command of users10. Matching keyword in database11. system allots rank to product as good, bad and ugly12. view product review13. users can use system to view product14. manage users account15. all users account allowed to be added or modified , and deleted by administrator   Non Functional Requirements: 1.     Efficiency 2.     Interoperable 3.     Portability 4.     Security  Answer the following questions prefer to the previous requirements? question 1: Key-Based Data Model (It shows the entities and the primary keys)