Database Design Assignment - Marks and Spencer

Added on - 12 Nov 2020

  • 41

    pages

  • 7055

    words

  • 7

    views

  • 0

    downloads

Showing pages 1 to 8 of 41 pages
Database Design
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................3Part 1................................................................................................................................................3P1 Design a relational database system with the help of design tools and techniques..........3Relational database of Marks and Spencer (E-commerce):............................................................5Part 2..............................................................................................................................................12P2 Develop the database system with evidence of user interface, output and data validations12P3 Implement a query language into the relational database system...................................26Part 3..............................................................................................................................................30P4 Test the system against user and system requirements...................................................30Part 4..............................................................................................................................................34P5 Produce technical and user documentation.....................................................................34CONCLUSION..............................................................................................................................38REFERENCES..............................................................................................................................39
INTRODUCTIONDatabase design is a group of process that is helpful for designing, implementing andmaintenance of organization in database management system. Database design is helpful forproducing different database to meet the requirement according to users. It is crucial part ofenterprises to improve the performance of database.Marks and Spencer is a leading organization that is uses different database tool to managethe entire business process effectively and efficiently. This report will discuss about therelational database system to design using different techniques and tools. The assignment alsodiscusses about the query language which implements in relational to database system. Further,this report will describe the user and technical documentation and test the system to identify theneed and requirement of database design (Al-Barak and Bahsoon, 2016). This report will discussabout the different software requirement specification which is required for creating databasemanagement system.PART 1P1Design a relational database system with the help of design tools and techniquesA database management system is software that allow hardware to perform different taskand functions such as storing, updating, deleting and modifying the data. Marks and Spencer isthe fastest growing organization and they use various tools and techniques to design an effectivedatabase for e-commerce business (Battaglia and Smith, 2017). In this way, they are providingdifferent product information and stored in the form of database system. There are someimportant steps helps for designing database system:1.Identifies the main purpose of system.2.Determine that what tables are needed for database.3.Identify unique values and fields.4.Determine the relationship between various tables.5.Refine the design6.Add some data to create the system object.Marks and Spencer is using SQL technique for maintaining their database system. Thisorganization is creating their own e-commerce application to create database (Kaneko, 2016). Italso builds theapplication code and logics in the database. E-commerce application helpful of
organization in context of managing the entire database system by using MS Access, SQLServer 7, Oracle 8 etc.Design of database-Customer table: Customer_id, customer_name, Customer_classProduct table: Product_id, product_name, Product_purchased date,Order table: Order_id, Payment_id, order_date,Order Details: Order detail_id, Product_id, Order_number, product_qualityDelivery: Delivery_id, delivery_date, supplier_idOrder detail delivery: delivery_id, order_id, order detail_idHeadquarters: Headquarters_id, branch_idBranch : Branch_id
Relational database of Marks and Spencer (E-commerce):
Database table-
Marks and Spencer is using e-commerce application to design relational database systemin proper table.In SQL server, they use high level relational database system to create table inproper ways. Relational database management system provides the service to user interact withthe organization.All the table shows information and details of particular product and theirdelivery (Kaneko, 2016). Marks and Spencer is using database system and requirement ofdatabase that is needed to store the information of company and customer in the form of databasemanagement system. In relational database, primary key is playing important role to create tableand each table hasunique rows and column is known as primary key. For Example, the uniquenumber is customer_id which is used as primary key in customer table and product_id is uniquenumber in product table. Primary key is used as a reference key of another table. They willgenerate unique value in database table (Currim and et.al., 2015). According to database table, itshows that the primary key has unique identity. A database create relationship betweenthetables in which database is design in different ways:One to manyMany to manyone to one
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document