This subject will provide a solid grounding in database design . It will show the importance of database design in the development of applications that meet business needs. Learning outcomes Upon successful completion of this subject, students should: • be able to model complex business rules using Entity Relationship Diagrams (ERDs); • be able to apply normalisation techniques to optimise a database design; • be able to use complex SQL commands to query a database; • be able to research a recent development in the field of database technology.
The subject content is listed in the Schedule below.
Passing a key subject is one of the indicators of satisfactory academic progress through your course.You must pass the key subjects in your course at no more than two attempts. The first time you fail a key subject you will be at risk of exclusion; if you fail a second time you will be excluded from the course.
All of your subject materials are available on the Interact site under the Topics link in the left hand side menu. I suggest that for each topic you read the learning objectives carefully, read the overview, have a quick skim of the text. Once you have got a feel for what the topic is about try and make a good set of notes under each of the topic review questions in that topic. These questions have been designed to give you focus in the topic, so it really helps to prepare a useful set of answers to them. In this subject there are also lots of opportunities for you to engage with me, with your peers and with the subject. I will be holding 12 regular sessions where we can discuss content issues and assessment items. As part of your assessment in this subject you are required to work alone for all the assessment items. The study guide and/or subject materials for this subject have been written specifically to guide you through the sections (and questions) of the prescribed textbook relevant to each topic. You should check the Interact Site at least weekly for postings, announcements, lecture information and other resources that will assist your studies or additional information and resources vital to your success in the subject.
Database research (approx. 200-250 words):
Note: you are expected to conduct research about current and future Database technologies by answering the below question: Research Question: Explore history of database systems and discuss the three most important developments in database development history to date. (1.25 marks each).
Note: Use proper references in the APA style. Your research report must be well presented using proper content organization.
Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using the following description of operations. Hot Water(HW) is a small start-up company that sells spas. HW does not carry any stock. A few spas are set up in a simple warehouse so customers can see some of the models available, but any products sold must be ordered at the time of the sale.
· HW can get spas from several different manufacturers.
· Each manufacturer produces one or more different brands of spas.
· Each and every brand is produced by only one manufacturer.
· Every brand has one or more models.
· Every model is produced as part of a brand. For example, Iguana Bay Spas is a manufacturer that produces Big Blue Iguana spas, a premium-level brand, and Lazy Lizard spas, an entrylevel brand. The Big Blue Iguana brand offers several models, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI-10, a 102-jet spa with three 6-hp motors.Every manufacturer is identified by a manufacturer code. The company name, address, area code, phone number, and account number are kept in the system for every manufacturer.
· For each brand, the brand name and brand level (premium, mid-level, or entry-level) are kept in the system.
· For each model, the model number, number of jets, number of motors, number of horsepower per motor, suggested retail price, HW retail price, dry weight, water capacity, and seating capacity must be kept in the system.
Create an ERD for each of the above statements that describe the current business rules for HW. For each new statement being the business rule.
Use Crows Foot notations and include all of the following in each part:
• All entities with Primary key and any foreign key attributes; (3 marks)
• The relationships between entities; (2 marks)
• The cardinality and optionality of each relationship; (3 Marks)
• Any M:N relationships are be resolved to 1:M relationships and ERD description is clear; (2 Marks)
• Include your Student ID and Full Name under the ERD (in Draw.io) then copy the whole ERD as an image to your Word Document.Additional 1 mark is given when following all the above correctly and producing aCharles Sturt University Subject Outline ITC556 .
The marking criteria for this assignment are:
Submit as a Word document: Add table of contents indicating part A and Part B. Embed your ERD as an image/object (use screenshot or snipping tools) into the Word document. Don't use any other file formats.Don't submit your file in XML.
Suppose that you have been given the table structure and data shown in Table below, whichwas imported from an Excel spreadsheet.The data reflect that a professor can have multiple advisees, can serve on multiple committees,and can edit more than one journal.
For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ. Manually drawing the dependency diagram, or the set of 3NF relations or the relationalschema is NOT acceptable.
This assessment task will assess the following learning outcome/s:
• be able to apply normalisation techniques to optimise a database design.
From Resources under Main Menu in Interact 2 go to Assignment 4 Folder Copy sqlite3.exe file from the Assignment 4 Folder into a folder in your machine Copy a4.txt from the Assignment 4 Folder into the folder in your machine where your SQLite file is located From the SQLite Command Prompt execute the a4.txt script. To do this, at the SQLite Command Line type .read a4.txt [to create the tables you will use to answer this assignment’s questions]
Academic integrity means acting with honesty, fairness and responsibility, and involves observing and maintaining ethical standards in all aspects of academic work. This subject assumes that you understand what constitutes plagiarism, cheating and collusion. If you area Charles Sturt University Subject Outline ITC556 201960 SM I Version 1 - Published 24 June 2019 Page 18 of 23 new student we expect you to complete the modules called Academic Integrity at CSU (http://student.csu.edu.au/library/integrity/academic-integrity-course). CSU treats plagiarism seriously. We may use Turnitin to check your submitted work for plagiarism. You can use Turnitin to check for plagiarism (http://student.csu.edu.au/library/ integrity/referencing-at-csu/checking) in your assessments before submission.
Referencing is an important component of academic work. All assessment tasks should be appropriately referenced. The specific details of the referencing requirements are included in each assessment task description. Get referencing style guides and help (http://student.csu.edu.au/library/integrity/referencing-at-csu) to use for your assessments.
How to submit your assessment items?
Online submission process Assessment items that are completed within the Interact 2 site, such as quizzes, tests and self and peer assessments in the blog and wiki are noted in the assessment section above. You need to complete these tasks within your subject site. Assessment tasks that are NOT completed through the Subject site need to be submitted electronically via Turnitin site by the due date. Turnitin class details for this subject will be given by your lecturer. Unless advised otherwise, all Turnitin submissions are due by midnight (AEST) of the date specified. Please note that the time and the date of your Turnitin submission will be used to determine your official submission time. All textual elements within an assessment must be submitted in a format that is readable by Turnitin. Specific exceptions, where an assessment requires the insertion of image-based evidence of workings will be outlined in the context of the assessment. Students that deliberately attempt to insert the content of assessments in a format that is not readable by Turnitin may be subject to Academic misconduct investigations. Additional Submission Information: It is recommended that your name, student ID and page number are included in the header or footer of every page of any assignment. You are also required to rename your assignment file before you submit via Turnitin as per below protocol:
Postal submission process
Under normal circumstances postal submissions will not be accepted for any of the assessments required.
Hand delivered submission process
Hand delivered submission process Under normal circumstances hand delivered submissions will not be accepted for any of the .
It is best to complete assessment items by the due date. However, when something unavoidable comes up an extension may be possible. The following principles are used when processing extensions:
1. For in-session assessment items, an extension request for up to three (3) calendar days can be made by emailing your subject coordinator directly before the due date. In your email please state the reason why you need more time as well as what precisely you are requesting. Supporting documentation is not required. If an extension is requested in the above format with a valid reason and your request does not disadvantage other students, the extension will be approved.
2. For in-session assessment items, extension requests of more than three (3) calendar days must be made via the special consideration form: https://apps.csu.edu.au/specialcons/. The request must be made before the due date and must include supporting documentation. Acceptable reasons are given in the Special Consideration Policy view.current.php?id=00298>. Each request will be considered on a case by case basis. The request may not be granted. The maximum extension possible will be seven (7) calendar days.
3. If you receive an extension, then you should expect the assessment item and its feedback to be returned later. If you submit later than the extended due date you will receive late penalties as per guidelines below.
4. Unless your extension permits otherwise, submissions received 10 days after the original due date will receive zero.
5. For end of session exams, you can request a supplementary exam via https://apps.csu.edu.au/specialcons/. This request must be made within 3 working days of the date of exam and must include supporting documentation. Acceptable reasons are given in the Special Consideration Policy medical issues, a CSU medical certificate is required. If the supplementary exam (SX) is awarded then your exam is moved to the next examination period. In order to preserve exam integrity and manage the logistics of exams, the timing of a supplementary exam.
How to apply for special consideration?
Academic regulations provide for special consideration to be given if you suffer misadventure or extenuating circumstances during the session (including the examination period) which prevents you from meeting acceptable standards or deadlines.Find the form on the Student Portal Special Consideration, Misadventure, Advice and Appeals (http://student.csu.edu.au/ study/academic-advice) page.
Write and run SQL statements to complete the following tasks (Each Query : 1.5 (0.75
query+ 0.75 for screenshot) Marks)
1. Show sums of line units for each invoice.
2. Show the details of the products that do not have a value for the attribute v_code.
3. Show the details of the invoices whose subtotal is greater than 24 but less than 76.
4. Show the details of the invoice who has the minimum subtotal.
5. Show the codes and names of the vendors who supplied products
. 6. Using EXCEPT show the codes of the vendors who did not supply any products.
7. Using ‘NOT IN’ show the codes and names of the vendors who did not supply any products.
8. List the names and codes of vendors and the number of products each vendor has supplied, i.e. vendor XXX has supplied xxx products, and vendor YYY has supplied yyy products etc.
9. Show the details of the employees who are located in area code 615.
10. Using inner join, list the details of the products whose line price is greater than 99.
You are required to submit:-
1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file. If you type .echo on at the SQLite3 Command Line, SQLite will output your SQL statement with the results of the query making it easy to copy and paste both.
2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file. Rationale.
Marking criteria and standards
The marking criteria for this assignment is:
Database research assignment help,Data Modelling assignment help,Instructions of data assignment help, Data Academic integrity assignment Help,Information Technology Assignment Help,Query databases assignment help.
Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...
55 - Completed Orders
Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...
52 - Completed Orders
Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...
102 - Completed Orders
To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...
109 - Completed Orders
JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...
202 - Completed Orders
Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...
20 - Completed Orders
Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...
100 - Completed Orders
Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...
200 - Completed Orders
I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...
109 - Completed Orders