CIS305 Project 1
The project is designing a complete database management system to address a practical database need and implementing a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization.
The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Pine Valley Furniture Company (PVF ). PVF is in the business of wholesale distribution, whereby they purchase most of their products directly from various manufacturers, and then they sell these products to their customers. PVF can actually fabricate some of the products they sell, in addition to purchasing them from the manufacturers.
The initial entities for your model are CUSTOMER, ORDER, and PRODUCT. In addition to these initial entities, you are provided with several business rules.
You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as, inaccurate or incomplete work. Your grade represents your pay.
CUSTOMER ( CustomerID, CustomerName, CustomerAddress, CreditLimit)
ORDER (OrderID, CustomerID, CustomerPoNumber, OrderDate, DueDate, ShipDate)
PRODUCT( ProductID, ProductDescription, UnitPrice, StockQuentity)
Begin with the initial entities for CUSTOMER, ORDER, and PRODUCT provided above, transform them into relations, and normalize your model to 3rd Normal Form. This is your deliverable #1. Realize that the three entities (or the three converted relations) are not in 3rd Normal Form. This is obvious by the many-to-many relationship that would need to exist between ORDER and PRODUCT. You are to do the steps necessary to obtain 3rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come with (and their relationships) once you have achieved 3rd Normal Form. Hint: You answer will be within the Word document you submit as your Project 1 Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships). This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships.
In Deliverable 2 you will start with a copy of your Deliverable 1, and build upon it by adding the necessary functionality to support the following business rules:
Each customer may place multiple orders, and each order may consist of multiple products
Each Customer is serviced by a Sales Representative that is an employee of PSC. A Sales Rep may service multiple customers.
Employees that are Sales Reps are paid commission on their sales based on a commission rate for the Sales Representative. Different Sales Reps may have different commission rates.
All products are purchased from suppliers, and multiple suppliers can provide each product; however, some products can also be fabricated by PSC. Different suppliers charge different amounts for the products. Fabricated products consist of a Bill of Materials that describes the components (parts) of each product. Component parts are products too.
Each employee is required to complete a series of PSC courses. It is essential to document the courses employees complete, as these skills are used to evaluate promotion eligibility.
In Deliverable 2, You will add the additional relations and relationships t the relational schema you created in Deliverable 1. You must maintain 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order, and be sure to include the relationships between the relations (all of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order. Be sure to use the correct capitalization formatting with RELATION names being singular and in ALL CAPS while attributes are presented using ProperCamel notation. Remember that this logical schema is a listing of the relations and relationships, and it is not in the same format as an ERD.
Contains the same information as Deliverable 2, except in a different format. Deliverable 3 is an Entity Relationship Diagram (ERD) that you develop in ERwin. All of the functionality indicated in the business rules must be present. Also, this exercise is an excellent opportunity to show your understanding of Enhanced Entity Relationship Diagrams (EERD), as you will have the opportunity to demonstrate Supertype/Subtypes. A helpful hint here is to take a screenshot of your Erwin ERD instead of printing it. Erwin places a big watermark description across the page when you print using the free Community Edition of the software; however, if you simply take a screenshot, then the watermark does not appear. All entities, attributes, and relationships must be properly labeled. Although they are presented in different visual formats, the information contained on this Deliverable 3 Erwin logical data model (ERD) must exactly correspond to the information contained on Logical Schema of deliverable #2
Within a Word document, submit all three deliverables in the exact order specified.
Deliverable 1 with consist of the logical schema showing the relations and relationships
Deliverable 2 will be in the same formation as Deliverable 1, but it will contain many more relations and relationships
Deliverable 3 will contain the same information as Deliverable 2 but it will be in a different format. Deliverable 3 will be in the format of an ERD, and you will develop your ERD in ERwin. You must also attach a copy of your erwin file.
Include a table of contents.
Follow the instructions provided within the course syllabus regarding submitting projects
The first two deliverables must show relations and relationships
The third deliverable mush show entities, relationships, attributes, cardinalities and keys.
You must name your files using the syntax of LastnameFirstInitialLab1. So, be sure to name your .docx and your .erwin files using our last name, first initial, and “Lab1” as the file names.
Use VISIO to present the Diagrams
Logical Database Design and the Relational Model
Project Submission Requirements:
Be sure to read and follow the project submission instructions located on the course syllabus.
You must submit your Word document with your Project and a copy of your Erwin file.
The starting point of your project is to identify a database need of a real client, and explore questions such as:
What is the purpose of the database? Why is it needed? What should it do?
Who is the client/user?
What is the problem/challenge in general?
How can the problem be solved?
Why is the project important?
Who are the users and what are their information needs?
What input data is available to the database?
What kind of information should be stored in the database?
Why Choose Us
At Myhomeworkwriters.com, we always aim at 100% customer satisfaction. As such, we never compromise o the quality of our homework services. Our homework helpers ensure that they craft each paper carefully to match the requirements of the instruction form.
Professional Academic Writers
With Myhomeworkwriters.com, every student is guaranteed high-quality, professionally written papers. We ensure that we hire individuals with high academic qualifications who can maintain our quality policy. These writers undergo further training to sharpen their writing skills, making them more competent in writing academic papers.
Our company maintains a fair pricing system for all academic writing services to ensure affordability. Our pricing system generates quotations based on the properties of individual papers.
My Homework Writers guarantees all students of swift delivery of papers. We understand that time is an essential factor in the academic world. Therefore, we ensure that we deliver the paper on or before the agreed date to give students ample time for reviewing.
Myhomeworkwriters.com maintains a zero-plagiarism policy in all papers. As such, My Homework Writers professional academic writers ensure that they use the students’ instructions to deliver plagiarism-free papers. We are very keen on avoiding any chance of similarities with previous papers.
Customer Support 24/7
Our customer support works around the clock to provide students with assistance or guidance at any time of the day. Students can always communicate with us through our live chat system or our email and receive instant responses. Feel free to contact us via the Chat window or support email: firstname.lastname@example.org.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Homework Writing Services
My Homework Writers holds a reputation for being a platform that provides high-quality homework writing services. All you need to do is provide us with all the necessary requirements of the paper and wait for quality results.
At My Homework Writers, we have highly qualified academic gurus who will offer great assistance towards completing your essays. Our homework writing service providers are well-versed with all the aspects of developing high-quality and relevant essays.
Admission and Business Papers
With Myhomeworkwriters.com, we will help you secure a position at your desired institution. Our essay writing services include the crafting of admissions papers. We will still help you climb your career ladder by helping you write the official papers that will help you secure a job. We will guide you on how to write an outstanding portfolio or resume.
Editing and Proofreading
Myhomeworkwriters.com has a professional editorial team that will help you organize your paper, paraphrase it, and eliminate any possible mistakes. Also, we will help you check on plagiarism to ensure that your final paper posses quality and originality.
My Homework Writers harbors professional academic writers from diverse academic disciplines. As such, we can develop homework writing services in all academic areas. The simplicity or complexity of the paper does not affect the quality of homework writing services.