Ask a question from expert
Database Design Assignment Solution
41 Pages3865 Words434 Views
Added on 2020-10-05
Database Design Assignment Solution
Added on 2020-10-05
BookmarkShareRelated Documents
Database Design
Table of ContentsINTRODUCTION...........................................................................................................................3MAIN BODY...................................................................................................................................3P1 Design a relational database system of online fashion outlet shop by using the SQLmanagement studio techniques. ..................................................................................................3D1 The effectiveness of the design in relation to user and system requirements. ......................8P2 Develop the database system with the evidence of user interface, output data validation andquerying across the different tables. ...........................................................................................8D2 Evaluate the effectiveness of database solution in the relation to system and userrequirement................................................................................................................................19P3 Implement a query language into the relational database system. .......................................19P4 Test the system against the user and system requirements. .................................................25Test verification and validation process-...................................................................................28P5 Produce the technical and user documentation.....................................................................28D3 Future improvement that may require to ensure the continued effectiveness of databasesystem. ......................................................................................................................................30CONCLUSION..............................................................................................................................31REFERENCES..............................................................................................................................35
INTRODUCTIONData base design can be termed as the organisation of the data according to the modelwhich helps in determining the type of data stored in it. Data base design involves classifyingdata and identifying interrelationship. This study will help in developing a database design forthe fashion outlet in London in order to provide online facilities for the users. The databasedesigning of the fashion outlet is aimed at developing the relational database system whichallows the storage of customer details, order items, payment and employee details. This databasedesign will help the retailing company in improving the operational efficiency and also provideeasy access to the data and information regarding the day to day transactions. Moreover, the report will discover the appropriate entity relationship diagram whichdisplays the relationship of different entities with each other along with the attributes and fields.It will help in developing the database with the suitable tool known as SSMS Or structured queryLanguage. It will also enhance the understanding about development of the ERD to implementthe Querying statement to insert, update, delete and modify the data into the tables. Testing thesystem is one of the important requirement so it will explore the testing phase of the database inorder to carry out the system as well as user requirements. It will also present the technicle anduser documentation.MAIN BODYP1 Design a relational database system of online fashion outlet shop by using the SQLmanagement studio techniques. Entity relationship diagram for the entities along with the attributes.Entity relationship model is basically describes the interrelated things of interest in thespecific domain of knowledge. ER is composed with the different entities types and specificrelationship that already exist between the entities (Bjeladinovic, 2018). It is commonly formedto represent the things a enterprise requirements in order to perform business process,consequently ER become an abstract of data model that define information or data structurewhich can be implemented in relational database.
Entity-An entity is a real world object that are represented in the relational database and it canbe any object, person and class. Data and informations are stored in the form of entities in theDBMS. According to ERD, There are several type of entities used in the database system such ascustomer, payment, categories, cart and item etc. Attributes-It refers to the database component in the form of table and describe the instances in therow of DBMS (Hogan, 2018). Attributes are simply the one of non null cell in spreadsheet. Itstores only one pieces of data about the object that represent buy the table. As per ERD, it hasrepresented the attributes such as customer_id, name, phone no, payment_id, type etc. These arethe different type of attributes shows in the database tables.
Primary Key-Primary key is a special type of entity and attributes that uniquely define the record in thedatabase table. In customer tablePrimary key: customer_idIn online shopping sitePrimary key : reg_noIn payment tablePrimary Key : payment_idIn cart tablePrimary key : cart_idIn categories table Primary key : category_idIn item tablePrimary Key : item_idIn order tablePrimary Key : order_idForeign Key-Foreign key is basically the field in one table that uniquely determine the row of anotherand same table. It can use to create relationship between two tables in proper manner. It shows asreferences primary key into another table. Mapping into the relational ModelEntities :Online Shopping siteReg_noNameWeb_addressCustomerCustomer_idCustomer_nameCustomer_addressCustomer_phonePayment
Payment_idPayment_amountPayment_typeCartcart_idCart_total costCategoriesCategories_idNameTypeItemitem_idNameitem_priceEmployeeemp_idemp_firstnameemp_lastnameemp_phone noemp_genderemp_salaryemp_addressemp_DOBemp_hiredateOrderOrder_idorder_nameorder_typeorder_statusM1 Produce a design for a fully functional system which includes interfaced, ouput design s andnormalization. Normalization Concept (1NF, 2NF and 3NF)Normalization is a type of process that help to organize the data and information in thedatabase system. This process is used to minimize the redundancy from the relation and set ofrelations. It also help to eliminate the undesirable characteristics such as Anomalies, update,deletion and update etc. This process will help to divide a larger table into the smaller tables andalso link between them using relationship. It can be divided into three different forms such asFirst Normal Form (1 NF)If a relation may contain the composite and multi valued attributes, it also violates theform normal form and relations is in the 1NF. A first normal form said to be 1 NF if eachattributes of relation is atomic. In this way, each row in the table should be determined the primary key
There is no row of data repeating the column values and group. Second Normal Form (2 NF)To be in the 2NF (second normal form), a relation must be in the first normal form and itmay not contain any type of partial dependency. In 2NF, it has no partial dependency and noprime attributes. Each and every key attributes are determined by using primary key.All type of sub type data which applicable to the multiple rows in the table and alsoremove or place in another table. New generated table should be related the foreign key. Illustration 1
Third Normal Form (3 NF)In third norm form, it has no transitive dependency for the non prime attributes is in the 2NF (second normal form). This normal form should meet all the requirements of both 2NF and 1NF. In case, any column which are not matched to primary key so that it can remove them and also put the another separate table. D1 The effectiveness of the design in relation to user and system requirements. It is important to establish and documents the users requirements and needs so that canlead into the design process of system itself. User requirement must be included the overalldescription of every task when the system will support the functions. Without having theeffective design, it is not possible to identify the actual processing of database system. System design phase is initiated and also ensure that the system requirements or capturein the repositories. It also mapping with the task and functions of system requirement. P2 Develop the database system with the evidence of user interface, output data validation andquerying across the different tables. Online Fashion outlet shop has developed the database that manage all type of operationsand their functionality. This is the graphical user interfaces when user can easily execute thequeries and tables. However, The GUI provided by each database server where the online shophas own database sever to operates with the technical knowledge. Illustration 2Illustration 3
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design & Developmentlg...
|32
|3863
|417
Database Developmentlg...
|28
|3298
|349
Database Design and Developmentlg...
|27
|3992
|59
Relational Database Management System (RDBMSlg...
|43
|8083
|154
Database Design & Development TABLE OF CONTENTSlg...
|31
|5485
|361
Relational Database Management System pdflg...
|22
|564
|350