Relational Database Design and Implementation
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages
Relational Database Design and Implementation
Objective of Interview:
To determine the data that will be maintained in the school system
Interview Date: 09/24/2017.
Interview Location: city, state
Start Time of the Interview: 1:30 pm
End Time of the Interview: 2:30 pm
Customer Participant(s): first Last .
Project Team Participant(s): first last
- Is the data you suggested during the first interview sufficient? Yes No
- Do you have a limit to the amount of data to be stored in the database? Yes No
- What data should be maintained in the database?
Students’ details, Parents’ details, Test scores, Fees details
- f these data do you want included in the database?
Data Data Characteristics
Student Name, age, gender, class, parent’s name, Account number, cell phone, address, email, birthdate, ID number
Parents Name, Child’s name.
Teacher Name, Subjects they teach
Sports Types, students, trainer, awards.
- Are the designers of this database free to add additional data they deem appropriate?
Yes they are so long as any board member reviews the data before launching of the database.
Student: Name, Gender, age, parent, Cellphone, Email, classes, grade.
Parent Name: Child, cellphone, Email, occupation, marital status.
Teacher, Name, subjects, cellphone, Email.
Sports: Types, students, trainer, awards.
Health: Diseases, blood type, medication, special needs.
Harrington, J. L. (2009). Relational Database Design and Implementation. 3rd Ed. Amsterdam : Morgan Kaufmann. Retrieved from
Eriksson, U. (2012). How to use interviews to gather requirements. Retrieved from:
Creating the School Sample Database (2010). Microsoft. Retrieved from:
The entity-relationship (ER) diagram is a modeling tool used to create and depict the logical structure of a database. You have interviewed your customer/stakeholder for his/her database management needs in “Conduct Client Interviews” (M2A1) you will take that information and create a preliminary ER diagram for your stakeholder. Please use the IE table/relation notation (also called crow’s foot notation) specified in (Harrington, 2009, pages 70-71) to create the ER diagram.
Using Microsoft Visio or an open source alternative such as Dia, create an entity-relationship model for your data management need that you previously documented. when assembling your diagram:
- All entities should have an identifier/primary key
- All attributes should be scalar (i.e., have one and only one value)
- All attributes should have an appropriate data type
- Relationships should be clearly notated with their cardinalities (you may need to create new attributes as foreign keys in order to specify relationships)
- You should convert M:N relationships to composite entities
- There might be weak entities in the diagram
Place a explaining any important or interesting design decisions you made, such as identification and creation of composite entities or weak entities, or how entities are related.
Compose your work in a .doc or .docx file type using a word processor (such as Microsoft Word, etc.) and save it frequently to your computer. For those assignments that are not written essays and require uploading images or PowerPoint slides, please follow uploading guidelines provided by your instructor.
Important Decisions and Assumptions made during constructing ERD.
- Each student is identified using a unique number throughout the student’s school year
- Each teacher has a unique code that identifies him or her
- A teacher must be certified by a board and given a unique number.
- A parent can have one or more students in the school
- A teacher must oversee any sport
- A teacher can teacher can teach 2 or 3 subjects.
- A weak entity is the contact details since the student and the parents share the same contacts. So, the primary key of both is used to make the table.
Harrington, J. L. (2009). Relational Database Design and Implementation. 3rd Ed. Amsterdam: Morgan Kaufmann. Retrieved from http://vlib.excelsior.edu/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=nlebk&AN=319641&site=eds-live&scope=site
Microsoft. (2016). Tutorial for Visio 2016. Retrieved from:
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.