Database Design & Development
32 Pages3863 Words417 Views
Added on 2020-11-23
Database Design & Development
Added on 2020-11-23
ShareRelated Documents
Database Design & Development1
ContentsINTRODUCTION...........................................................................................................................3P1 Design a relational database system by using the appropriate design tool, technique andcontaining the interrelated tables.................................................................................................3Entity:..........................................................................................................................................4D1 Effectiveness of design in the relation to system and user requirement................................8P2 Develop the database system with the evidence of user interface, output and datavalidations and querying across multiple tables..........................................................................9M1 Implement the functional database system that involves system security and databasemaintenance...............................................................................................................................15D2 Evaluate the effectiveness of database solution in relation of user and system requirement....................................................................................................................................................15P3 Implement a query language into the relational database system........................................16P4/ M4 Discuss about the test system against user and system requirements...........................26P5/ M5 Produce technical and user documentation..................................................................28D3 Discuss the Improvement in future which require to ensure the continued effectiveness ofdatabase system.........................................................................................................................29CONCLUSION..............................................................................................................................30REFERENCES..............................................................................................................................312
INTRODUCTIONDatabase is a collection of inter related data which help for inserting, deletion andretrieval of data from the database system. It is also organised the data in the form of tables,reports, schemas and views etc. It useful for managing the large amount of data and informationin the database system. This report will discuss about the Fashion outlet which is based on theonline shop to design the database for increasing the productivity and profitability. It can bedesigned the database system that store the information regarding the consumer, orders, itemsand payment, employee details etc. It allows to user access the information about the product thatprovided by the online shop for Fashion outlet expansion. Furthermore, this report will discuss about the Entity relationship model which requiredfor designing database because it is determined the important entities and create a relationshipbetween them. It will describe the ERD diagram for the entities along its attributes throughNormal forms. Moreover, it will produce the technical and user documentation that can use forthe designed database. P1 Design a relational database system by using the appropriate design tool, technique andcontaining the interrelated tables.An Entity relationship diagram is basically set entity that stored in the database system. Itis a type of high level conceptual data model which based on the real entities to createrelationship with one or more. It helps to analyse the requirement of data in systematic manner toproduce the well-designed database system. Entity relationship Model allows to construct the database design and also considered therequirement of system. It is very easy to use as the graphical tool for the purpose of data modelling. It is widely used in the database design and representing the logical structure of DBMS. It useful to determine the entities that exists in the database system and create relationshipbetween them. 3
Figure 1: Entity relationship DiagramEntity:An entity is a type of object in the system that create model and store information in thedatabase. It is generally applicable to recognise the concepts, abstract which are relevant to thedatabase. An entity is the analogues to the table in the relational model.There are several type of entities Attributes:An attributes is an item of data which are stored in the form of entity. Each and everyentity are containing the specific attributes. It can be represented in the ER model to represent inthe appropriate manner. 4
Data Dictionary:EntitiesAttributesData typeCustomerCustomer_id (PK)Customer_nameCustomer_emailCustomer_phone noCustomer_addressOrder_id (FK)IntegerVarcharVarcharIntegerVarcharintegerOrderOrder_id (PK)Order_typeOrder_statusOrder_nameIntegerCharacterVarcharvarcharProductProduct _id (PK)Product_nameProduct_priceProduct_typeProduct_weightCategory_id (FK)Customer_id (FK)IntegerVarcharNumberVarcharRealIntegerintegerPayment Payment_id (PK)AmountPayment_typeIntegerNumbervarcharCategoriesCategory_id (PK)Category_nameCategory_typePayment_id (FK)IntegerVarcharTextintegerTable:15
Primary key:A primary key is a type of special relational database column that can design to uniquely determine the table records. It must contain unique values for each row or information and data. It has a minimal attribute in table that uniquely identifies the tuples in the form of tables. As per above table, it can be identified the primary key in each database tables. In customer table:Primary key: Customer_idIn order table: Primary key: order_idIn product tablePrimary key: product_idIn Payment table:Primary key: payment_idForeign Key: A Foreign key is a field in one table that uniquely determine the row of another or sametable. It can be defined in another table as a foreign key. It ensures the referential integrity of thedata and information. For Example-sIn customer table:Foreign key: order_id It has created a relationship with order table because in order table, id is a primary keythat represented as foreign key into another table. It has created one to many relationshipsbetween them. In product table, customer_id is a foreign key in table so that it has created a relationshipbetween customer and product table. 6
Normalization:Database normalisation is a type of process and method of structuring the relationaldatabase system of Fashion outlet (Birch, Gwinnett and Walker, 2018). In order to reduce thedata redundancy and help to improve the data integrity. 1.First Normal Form2.Second Normal Form3.Third Normal FormFirst Normal Form1NF is a property which create relation in the database system if the domain of everyattributes contain the atomic values and each attributes contain only single value in the system. Itis the simplest way to satisfy the requirement which allows the product price contain one or morevalues in database table. Second Normal Form2NF is another normal form in database that can fulfil the requirement when it does nothave any prime attributes and its functionality dependents on the subset of candidate key. It mustsatisfy the first Normal form. 7
Third Normal Form3NF is basically used to normalise the database design to reduce the redundancy orduplication of data. It is also ensured the referential integrity by ensuring second normal form. D1 Effectiveness of design in the relation to system and user requirement. The effectiveness of design in the relation which need to develop the documents thatconsists the need and requirement of users. In this way, it should include the overall descriptionof every task in appropriate manner (Coury and Semmel, 2018). It has required for designing aneffective database system that can fulfill the need of users. User easily access the details relatedthe fashion cloths, item through the database system. Without having effective design, it is notpossible to maintain the processing of system. It ensures that capture the system requirement forunderstanding the 8
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design Assignment Solutionlg...
|41
|3865
|434
Database Design & Development TABLE OF CONTENTSlg...
|31
|5485
|361
Database Design and Developmentlg...
|27
|3992
|59
Logical and Physical Database Design and DBMS Functionslg...
|10
|1108
|66
Database Management System : Doclg...
|22
|1217
|96
Data Modelling and Sql Language - Assignmentlg...
|18
|2256
|44