Am looking with Knowledge in DATABASE
2411
$25
- Posted:
- Proposals: 1
- Remote
- #1682539
- Archived
Description
Experience Level: Intermediate
General information for the website: JUST A SIMPLE DATABASE ASSIGNMENT
Database management system (DBMS): MySQL
Description of requirements/features: Part 1 - Sales, Purchase and Stock Database System (30 marks)
Submit answers in a single MS-WORD file. Use headings to clearly separate each task.
You are required to create a simple stock control system with a small number of common sense
attributes. The system should contain the following information
• Inventory details
• Customer details
• Sales order details
• Supplier Details
• Purchase order details
So consider what stock control is needed when a customer raises a sales order or an inventory
manager within the organisation raises a purchase order.
You need to identify the tables you require and the information that they are to contain. It is
recommended that sale and purchase orders have header and line details tables.
This is only a small system, do not over-complicate it.
1. Design – Marks
Create a entity-relationship 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.
2. SQL –
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 so as to create the relational database in MYSQL
3) Insert some data into each table
MAN6905 – Databases and Business Intelligence Assignment 2
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 stock levels for items
iii. identify customer total expenditure
3. FORM -
Using MS-ACCESS, link to the MYSQL database 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.
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.
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/features: Part 1 - Sales, Purchase and Stock Database System (30 marks)
Submit answers in a single MS-WORD file. Use headings to clearly separate each task.
You are required to create a simple stock control system with a small number of common sense
attributes. The system should contain the following information
• Inventory details
• Customer details
• Sales order details
• Supplier Details
• Purchase order details
So consider what stock control is needed when a customer raises a sales order or an inventory
manager within the organisation raises a purchase order.
You need to identify the tables you require and the information that they are to contain. It is
recommended that sale and purchase orders have header and line details tables.
This is only a small system, do not over-complicate it.
1. Design – Marks
Create a entity-relationship 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.
2. SQL –
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 so as to create the relational database in MYSQL
3) Insert some data into each table
MAN6905 – Databases and Business Intelligence Assignment 2
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 stock levels for items
iii. identify customer total expenditure
3. FORM -
Using MS-ACCESS, link to the MYSQL database 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.
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.
Extra notes:
Dennis O.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
25 Apr 2024
Kenya
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies