Higher Nationals in Computing
DATABASE DESIGN AND DEVELOPMENT
ASIGGMENT
<No.1>
Learner’s name: DO HAI NGUYEN
Assessor name: PHAN MINH TAM
Class: GCS0701B
ID: GCS18302
Assignment due: 1 6/ F e b / 2 01 9 Assignment submitted: 16/F e b / 2 0 1 9
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Database Design and Development Assignment, Essays (university) of Relational Database Management Systems (RDBMS)
Database Design and Development
Typology: Essays (university)
2019/2020
1 / 33
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Database Design and Development Assignment and more Essays (university) Relational Database Management Systems (RDBMS) in PDF only on Docsity!
Higher Nationals in Computing
DATABASE DESIGN AND DEVELOPMENT
ASIGGMENT
<No.1>
Learner’s name: DO HAI NGUYEN
Assessor name: PHAN MINH TAM
Class: GCS0701B
ID: GCS
Assignment due: 1 6 / F e b / 2 0 1 9 Assignment submitted: 1 6 / F e b / 2 0 1 9
Assignment Brief ElectroShop is a company who acquire and sell electronic devices to customers throughout Vietnam. They are looking to apply their current data store system with a relational database. The company takes orders from customers, who can order any quantity of many items that ElectroShop have in their current catalogue. The catalogue includes TV, Phone, etc. Each of ElectroShop’s suppliers supplies many items but each item is supplied by one main supplier. ElectroShop would like to add all the customers to the database so that they can send a mail-shot to them with any offers that are available, as well as the catalogue which is produced annually. Salespersons at ElectroShop are paid a monthly bonus which is determined by the amount of sales they have made for each month. The company would like the bonus calculated automatically by the system. As well as the monthly bonus figures ElectroShop would like to be able to create comparative reports from the system i.e. sales figures for each month this year compared to last year. Submission Format The submission is in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system
Higher Nationals - Summative Assignment Feedback Form
Student Name/ID Unit Title Unit 4: Database Design and Development Assignment Number Assessor Phan Minh Tam Submission Date Date Received 1st submission Re-submission Date Date^ Received^2 nd (^) submission Assessor Feedback: Grade: Assessor Signature: Date: Resubmission Feedback: Grade: Assessor Signature: Date: Internal Verifier’s Comments: Signature & Date:
- Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades decisions have been agreed at the assessment board.
P1. Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements.
1. Data and Databases definition In computing, data is information that has been converted into digital form, which make it more efficient for processing or storing in a computer. Data requires interpretation before being transformed into specific forms of information, such as text documents, images, audio clips, software programs or other types of data. A database is a collection of relevant data that is organized for the purpose of making it more easily to be accessed, manipulated and updated. In other words, database is a data structure that allows organizations to store, obtain and control information more efficiently. There are different main types of databases: 1.1. Flat file databases This is the simplest form with almost no protection for data integrity and security and often contain redundancy.
1.2. Hierarchical Databases Organized in tree-like structures, have same problems of redundancy, data integrity, and comparability of data. 1.3. Relational Databases Data is organized in tables that are related to each other. Each table has one or more columns assigned as primary key.
Pros Cons
- Available for free
- Supports standard SQL
- Fast, reliable and easy to use
- Handling a huge amount of data and good data management.
- Can work with other DBMSs like DB2, Oracle, etc.
- Customizable
- No built-in support for XML or OLAP
- Need to pay for support
- Difficult to debug
- Difficult to maintain
- Functionality heavily depends on add-ons 2.1.2. Microsoft SQL Server Microsoft SQL Server is an object-relational database management system (ORDBMS) developed, distributed and supported by Microsoft Corporation. It is built for the basic function of storing and retrieving data as required by other applications. This database management engine can run on local servers as well as cloud-based servers or can be optimized to work on both at the same time. MS SQL
Server allows users to store and manipulate terra bytes of data with various types like videos, images, text and much more. Pros Cons
- Fast, stable and reliable
- Provides excellent tools
- Easy to set up
- Work well with other MS products
- Different editions available
- Great support for XML
- Enterprise editions is extremely expensive
- Only run on Windows-based servers
- Compatibility issues with applications running on non-Windows platforms 2.1.3. Oracle Oracle is one of the leading SQL relational database management systems that is commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW)
- Latest innovations and features
- Exceedingly powerful tools
- Available in a variety of versions
- Need specialized skills to install and maintain
- Require significant resources
3. ElectroShop Databases ERD There is a variety of software and websites available on the Internet that come with many useful tools to design different charts and diagrams for specific purposes. The diagram given above illustrates the relationships among tables inside the database of ElectroShop by using Information Engineering Style Cardinality.
use this software to design the Graphical User Interface (GUI). Thereby, the managers and staff of ElectroShop will interact with the database more easily and effectively. First, we will create the database by executing the code below. According to my diagram, ElectroShop database contains 6 entities and therefore, we need to create 6 tables. Each table will be defined with attributes that have specific constraints and validations. They will be described in detail in the comments.
**2. ElectroShop Database Diagram
- ElectroShop Database GUI** I used Visutal Studio to create the GUI (Graphical User Interface) for the ElectroShop Database Manager program and it will look like this when we open it. There are 6 buttons that will open new
windows when we click them. Each window will interact with the corresponding tables in our database. PRODUCT When we click ‘Add’ or ‘Update’ the window below will pop up.