12 Jul METHODOLOGY OF RELATIONAL DATABASE DESIGN
As a postgraduate student taking CSC8500, you are expected to conduct a research project to demonstrate your understanding of the key concepts and methodology of relational database design that have been covered in the course.
In this project, you will need to conduct a task of database design from scratch. You need to specify a particular application scenario where the database is to be designed. For example, you can design a relational database for a university or a company or other organizations. In this project, you need to go through several major milestones in the database design lifecycle as taught in the course (relevant chapter/section in the textbook of the milestones is also noted below).
Please note that the database you design in the project will be subject to several requirements from views, conceptual design, logic design, functional dependencies and normalization. Please read the instructions below carefully for those requirements before designing your database.
System definition (Chapter 10.4)
You need to describe the scope and boundaries of the database system and the major user views that will be involved. Typically, the system boundary (scoping) of a database system is mainly about the specification of the functions to be delivered by the system with an emphasis on the limits of what the system can do.
It is expected that your database should provide at least three different (possibly overlapping) views. Besides using the circles to visually present different views, it is also required to provide the detailed description of different views including who they are, what are their needs, and how they are going to use the database system, etc.
2. Requirements collection and analysis (Chapter 10.5)
You need to collect and analyze the information about the part of the enterprise/organisation to be served by your database. Information is gathered for each major user view about the description of the data used or generated and the details of how these data are to be used or generated. Then, such information is analyzed in order to identify the requirements or features to be included in the database systems.
You need to utilize one of the two approaches discussed in Section 10.5 to manage multiple user views.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.