Test the system against user and system requirements

Reference no: EM133353238

Assignment - Portfolio - TOP Hair dressing

Learning Outcome 1: Use an appropriate design tool to design a relational database system for a substantial problem.
Learning Outcome 2: Develop a fully functional relational database syetm, based on an existing system design.
Learning Outcome 3: Test the system against user and system requirements.

Scenario

Topic - TOP Hair dressing - Hair dresser, with many clients and treatments carried out.

You have been provided with a topic. You are to supply a report containing the following deliverables: -

Question 1. Analyze the business you are devising the database system for. Describe the business rules, and data involved. Explain why the data is important to the information system being developed. Related to your specific topic, discuss the legal and ethical issues involved in managing your data.

Question 2. Using the Oracle Data Modeler Tool DRAW AN ERD DESIGN: AT LEAST 4 OR 5 entities ARE EXPECTED. Include attributes, cardinalities and relationship names. Ensure the diagram is readable.

Question 3. List the Relational Table Headings. Show clearly any primary keys (underlined) and foreign keys (shown with an *, or in italics). Your tables must match your ERD, otherwise 0 marks. Select suitable primary keys for every table.

Question 4. Use MySQL or SQL server and Create your database (ensure you save your CREATE TABLE statement). Highlight any additional constraints added. Ensure AT LEAST ONE table has a COMPOSITE PRIMARY KEY. The primary and foreign keys should be added at the same time as your CREATE TABLE statement, i.e., do not use ALTER TABLE to add them after.

Question 5. Populate all the tables with data (having 8 or more rows per table). Show all rows, (use SELECT * from <tablename>;) of data in every table created. Good/suitable TEST DATA created. Note, the tables at the many end of a relationship should contain more data. (P3,M3,D3)

SQL & QUERIES:
Devise 6 SQL queries that demonstrate appropriate use of the following:

Question 6. Use of the BETWEEN logical operator;
Question 7. AN example of DISTINCT within your query
Question 8. TO_CHAR function;

Question 9. An aggregate function in the SELECT list
Question 10. A GROUP BY command
Question 11. A SUBQUERY;
At least one of the above queries should include data from more than one table and a different query should demonstrate the use of an OUTER JOIN. (P3,M3,D3)

Include the following for each query:
- A short sentence saying what the query is doing
- SQL Query
- Result

Question 12. Devise a DELETE command that tests the foreign keys (testing of the referential integrity of the PK-FK relationship). Explain any error message.

Question 13. Use an UPDATE command to test the foreign keys. Explain what the error message means.

Question 14. Use an INSERT command to test the primary key (test the entity integrity), explain what the error message means.
(Include the query and comment on any results. Show at least 2 queries for each part (l-n): one that works successfully and one that does not.) (P3,M3,D3)

Reference no: EM133353238

Questions Cloud

How wealth and poverty are made under capitalism : how wealth and poverty are made under capitalism- particularly a capitalism shaped immeasurably by slavery and racism." What examples that he discusses

How might knowing these facts help us understand prejudice : Write a brief paragraph summarizing what you imagine the racial and ethnic makeup of the United States and your home state. Write a brief paragraph comparing

Why did protection at the ballot box for african americans : How and why did Congress fail to provide "protection at the ballot box" for African Americans?

How much proof is enough proof for controversial opinion : When has an argument you gave to someone provided enough evidence to establish its conclusion? How much proof is enough proof for a controversial opinion?

Test the system against user and system requirements : Unit 4 Database Design & Development - Assignment - Portfolio - TOP Hair dressing - Develop a fully functional relational database syetm, based on an existing

How do you manifest the spirit of service in jesus way : Are you more likely to help when a colleague asks you for help (called reactive helping) or when you perceive the need for help without being asked

Cultural expression be communicating about wellness : What social message might your cultural expression be communicating about wellness? What might be the social implications of this message?

Foundation cultural competencies to bridge cultural : Describe an instance that is seen at work or in other situations of the use of the foundation cultural competencies to bridge cultural differences.

What is the relationship between the mental health issue : What is the relationship between the mental health issue and the two social institutions which are the education and medicine? Could you please explain

User Account

All Pages