DBA 1. Fix the below draft business requirements to make it more clear and perfe
ID: 3783343 • Letter: D
Question
DBA
1. Fix the below draft business requirements to make it more clear and perfect, for it is very unclear and not good enough for you to complete the next task.
2. Base on your new updated business description; please mark all of the potential entities, attributes, relationships, and instances (please highlight them using different colors).
I’m the manager of a training company that provides instructor-led courses in management techniques. We teach many courses, each of which has a course number, a course name, and a tuition fee. Introduction to Oracle and C# Programming are two of our more popular courses. Courses vary in course length from one day to four days.
An instructor can teach one or several courses. Dr. Frank Chao and Peter Chen are two of our best instructors. We track each instructor’s first name, last name, Email, and instructor’s phone number. Each course is taught by only one instructor. We create a course and then line up an instructor.
The students can take several courses over time, and many of them do this. Ms. Jennifer Lopez from AT&T took every course we offer! We track each student’s student ID, gender, first name, last name, Social Security Number, phone number, and their employer name. Some of our students do not give us their Social Security Number and employer name.
Students need to check their course schedules before registering their courses. We track each course’s start date, end date, course number, instructor name, and classroom location (or address), building name, classroom number, and class status (full, not full, or canceled).”
Explanation / Answer
We, as programmers, are constantly being asked 'How long will it take'?
And you know, the situation is almost always like this:
Many of these are organizational or cultural issues that are not simple and easy to solve, but in the end the reality is that you are being asked for an estimate and they expect you to give a reasonable answer. It's part of your job. You cannot simply say: I don't know.
As a result, I always end up giving estimates that I later realize I cannot fulfill. It has happened countless of times, and I always promise it won't happen again. But it does.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.