Order custom papers, masters thesis and dissertation in 3 guided steps; human written!
Posted: January 31st, 2023
Introduction In this assignment you will apply critical thinking and technical skills to solve authentic business problems. It is important that you: ? Conceptualise problems or situations; ? Apply technical skills to authentic situations; ? Solve the complex problems; Submission Submit all answers in a single MS-WORD file. Use headings to clearly separate each task. Part 1 – Sales and Marketing Management Database System (30 marks) You are required to create a sales and marketing management system with a small number of common sense attributes. The system should contain the following information ? Sales details ? Marketing details ? Customer details ? Production details ? Delivery details ? Management details So consider what sales and marketing system is required to deliver a consistent and customer oriented service to all customers over the world. You need to identify the tables you require and the information that they are to contain. This is only a small system, do not over-complicate it. 1. Design – Marks 10 Create an entity-relationship (ER) model drawn with MS WORD or POWER POINT if you prefer. You are required to submit a print out of your database schema: ? Set of normalised tables – with your sample data. ? Indicate the table relationships using multiple keys; PK, FK, and SK using UML notation. Edith Cowan University MAN6905 – Databases and Business Intelligence Assignment 2 2. SQL – Marks 10 Use MYSQL to create the set of database tables of the relational database model and complete the associated queries given. Procedure: 1) Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys. 2) Execute each statement in the correct order to create the relational database in MYSQL. 3) Insert some data into each table. 4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench 5) Write in MS Word and execute in MYSQL WorkBench the statements necessary to; i. display all tables, ii. identify sales total for each item iii. identify delivery confirmation of sold items iv. identify marketing level for sold items 3. FORM - Marks 10 Using MS-ACCESS, link to the MYSQL database (see the instructions in MYSQL Connection from ACCESS on Blackboard) and create forms to enter sales and purchase orders. ? No buttons are necessary, just what ACCESS generates to scroll forward, add a record etc. ? Make it clear what the forms do in the Form by adding text or headers. ? Note: If you don’t own MS-ACCESS, do this part of the assignment in the lab. Summary For this part of the assignment you are required to submit: (a) A detailed database schema diagram drawn in Excel or PowerPoint (b) The required SQL CREATE TABLE and SELECT statements (c) The result of all SQL statements run in MYSQL Query Browser as screen shots to demonstrate correct execution of the statements (d) The required MS-ACCESS screen shots.
You Want Quality and That’s What We Deliver
We’ve put together our writing team with care, choosing talented writers who shine in their fields. Each one goes through a tough selection process, where we look for folks with deep expertise in specific subjects and a solid history of academic writing. They bring their own mix of know-how and flair to the table, making sure our content hits the mark—packed with info, easy to read, and perfect for college students like you.
We don’t do AI-written essays or copycat work—everything’s original. Competitive pricing is a big deal for us; we keep costs fair while delivering top-notch quality. Our writers are some of the best out there, and we charge rates that stack up well against other services. This means you get stellar content without draining your wallet. Our pricing is straightforward and honest, built to give you real value for your money. That’s why students turn to us for high-quality writing services that won’t break the bank.
Academic integrity is at the heart of what we do. Every paper starts from scratch, with original research and writing tailored just for you. We write 100% authentic—no plagiarism research essays. Our strict quality control process includes scanning every draft with top tools like SafeAssign and Turnitin, so you get a similarity score and proof of originality. We’re obsessive about proper citation and referencing too, crediting every source to keep things legit. It’s all about giving you peace of mind with content that meets the highest standards.
When you decide to place an order with Dissertation Writer, here is what happens: