Understanding of database and website design

Assignment Help Database Management System

Reference no: EM133524220

Database and Web Design

Objective - Demonstrate your knowledge and understanding of database and website design.

Problem Description
You work for a manufacturing company that specializes in producing a variety of products. You have been contracted to design a simple database system that effectively manages products, ingredients, and suppliers for this manufacturing company.

The company produces various products, each composed of specific ingredient(s) from different supplier(s). Each product has name and price. The company also wants to maintain each supplier's contact information such as name, address, and phone number for future use. A supplier can supply multiple ingredients. Each ingredient has a name and price per kg. The system should also keep track of the ingredients used (in kgs) for each product.

Task 1: Designing a database from the problem description

Designing a database consists of 4 basic steps.

Task 1.1: Complete the following questions according to the problem description
Identify the possible entities in the problem description.
Identify the attributes in the problem description.
Identify how the entities relate to each other (the relationships)
Identify (if any or create) attribute(s) that could be used as primary keys for each entity.

Task 1.2: Create an ER diagram
You can do this in any program of your choice (e.g., MS Word, draw.io (online), etc.). Either paste the diagram directly or take a screenshot of your ER diagram and paste it your word document. Your ER diagram should have all the entities, attributes, relationships, primary keys (underlined) and cardinalities (1-1, 1-M, M-1, M-M).

Task 1.3: Convert the ER Diagram into tables
For this task, you are not required to implement the tables in any RDBMS. You are just required to write the schema, i.e., table name, attributes, primary keys, and foreign keys, as shown in the lectures/labs.
This is a step-by-step process:
Create one table per entity.
Each attribute of the entity is represented as a column in the table.
Define the primary key columns (underline them)
Add the foreign keys (write them in italic).

Task 1.4: Create tables using SQL
Create all the tables you have in Task 1.3 using SQL. Paste your queries in your word document. Your table creation should consider any primary keys/foreign keys.

Task 2: SQL Queries

With SQL, how can you return all the records from a table named "Suppliers" sorted Z to A by "FirstName"?

Write SQL query to select all the suppliers where their last name contains the letters "eo" and starts with a "J".

Consider a database table named "Supplier" with a single column "LastName" shown below.
Galland
Klingman
Melancon
Gess
Dones
Lamborn
Elizondo

Consider the SQL:

SELECT LastName FROM Supplier
WHERE LastName LIKE "%o%"
ORDER BY LastName
LIMIT 3 OFFSET 1

Write down the order each name will appear in the result. Mention "will not appear" next to a name if it won't appear in the result.

Task 3: Wireframe User Interfaces

You are to design wireframes for a product manufacturing company like problem description but not limited to the problem description.
Please consider what different pages you can use for your website design. Some examples can be Homepage, Dashboard/Analysis, Product List, Ingredients List, Add/Edit Suppliers etc. You can visit available similar websites for any manufacturing companies for your reference. You can think about the pages according to the problem description and add any additional details you may find relevant.

Note that you can wireframe the UIs according to your understanding and preference. We are looking for creativity for this task. You are required to at least have minimum of 5 different pages for your UI. You also need to show flow/interaction among different pages. You need to use Figma introduced in the lab to create your UI.

Share link of your work in word document, make sure the link is accessible to the teaching team - Huawei and Aseel. You can copy the link from the address bar while you're in "Present" mode, and paste it in your word document. DO NOT send the invite by email. DO NOT share your link with anyone else in class.

Attachment:- Database and Web Design.rar

Reference no: EM133524220

Questions Cloud

What is current year-to-date performance of the flcsx fund : What is the current year-to-date performance of the FLCSX fund on August 6th, 2023 with an answer and explanation?

What is relation between ethics and religion : What is the relation between ethics and religion? what would an emotivism say to appraise what you determine is the ethical form of conduct?

What are the effects on the initial embargoing countries : what are the effects on the initial embargoing countries and on the target country? Does this shift make the embargo more or less likely to succeed? Why?

Write paper on historical tenets of transcendental movement : Write a paper on the historical tenets of the transcendentalism movement. Make sure you show correlation of transcendentalism to the Christianity viewpoint.

Understanding of database and website design : CSE4IFU Database and Web Design, La Trobe University - Demonstrate your knowledge and understanding of database and website design and Designing a database

What does the law of succession deal with : What does the law of succession deal with and what are the two stages of this law? With regards to alterations to wills, what does a codicil do?

Describe in detail the situation involving workplace drama : Describe, in detail, the situation involving workplace drama and negativity. Interpret the manager's role in either fueling or permitting drama or negativity.

Explain how the expectation hypothesis can be related : Term Structure is the relationship between yield and time to maturity for any class of similar risk securities. Explain how the Expectation Hypothesis can be

How your situation impact you and other employees involved : Relate one of your own professional experiences to that of your colleague's. How did your situation impact you and the other employees involved?

User Account

All Pages