Premium Essay

Dbms Project

In:

Submitted By wburke121
Words 366
Pages 2
BUS 5610 Database Management - Conceptual Design Project
William Burke
Florida Institute of Technology

BUS 5610 Database Management - Conceptual Design Project
Conceptual Design
The New Shooz Company is a retail chain of footwear apparel sales. Each of the five store locations has an independent system. They have hired a consultant to design a database to keep track of their sales, customers, employees and location information to be used at all locations. The database will be distributed for the advantages of availability, system response and the ease of adding new store locations in the future (Scalibility). ("DDMS," 2012) The conceptual design of the database consists of six tables, including Customer, SalesPerson, Sales, Order, Inventory and Location. (see Figure 1) The design allows for salespersons to be associated with any one location and there is one common product inventory for all the stores so that items can be shared if necessary. In addition, there is a Price table that can hold alternate sales prices for items at select times.
The database table is a simple design with only the necessary items for tracking customers, sales, inventory and location sales. The relationships are binary, like salesperson is located only at one location at a time, and ternary, in the case of Sales Person, Customer and Inventory, with a sale as the intersecting item. Gillenson, M., et al. (2008).
The relationships are defined as follows: * Customer Table one to many binary relationship with Order Table * Order Table many to many ternary relationship with Inventory Table and Customer * Inventory Table one to one binary relationship with Price Table * Inventory Table many to many ternary relationship with Location and Order * Salesperson Table one to one binary relationship with Location Table
The Primary and Foreign Key constraints are as

Similar Documents

Free Essay

Netw 360 Ilab 2

...power can be measured in two ways: on the linear scale, by the number of watts that are being transmitted; and on a relative scale, by the number of decibels (dBs) instead of watts. Decibel milliwatt (dBm) is the logarithmic power ratio (in dB) of the measured power in milliwatts referenced to one milliwatt (mW). Notice that the reference point is specified as 1 mW = 0 dBm. 3’s and 10’s rules are shortcuts for estimating the increase or decrease of these power levels. In this lab, students will practice basic RF calculations, including · converting from mW to dBm; · converting from dBm to mW; and · estimating power levels using the 3’s and 10’s rules. Task 1: Converting between dBm and mW Applying the 3’s and 10’s rules, the relationship between dBm and mW is estimated as shown in the following (partial) table. 3’s rule|10’s rule| ……|……| 0.125 mW = -9 dBm|0.001 mW = -30 dBm| 0.25 mW = -6 dBm|0.01 mW = -20 dBm| 0.5 mW = -3 dBm|0.1 mW = -10 dBm| 1 mW = 0 dBm|1 mW = 0 dBm| 2 mW = 3 dBm|10 mW = 10 dBm| 4 mW = 6 dBm|100 mW = 20 dBm| 8 mW = 9 dBm|1,000 mW = 30 dBm| ……|……| Notice that as the mW value increases or decreased by the factor of 10, the dBm value increases and decrease by adding or subtracting 10. As the mW value doubles or halves, the corresponding dBm value increases and decrease by adding or...

Words: 894 - Pages: 4

Free Essay

Dbm/380 Learning Team Week Final Project

...Learning Team Week Final Project DBM/380 Learning Team Week Final Project The Huffman Trucking Company started in Cleveland, Ohio in 1936. The company is privately owned, and began as a single tractor-trailer company. This company is growing is size and acquiring rapid business growth. At present time, the company owns 800 road tractors, 2,100 45' trailers, and 260 “roll A on/roll-off" units. The Huffman Trucking provides logistics services to U.S. Government as well as to the private companies. (Huffman Trucking, 2012). Learning team D’s project is to develop database design documentation for Huffman Trucking for their fleet truck maintenance. Huffman trucking interviewed members of their staff from different departments and proposed entities and attributes for their database. Entities proposed are numerous: Parts Inventory Purchases, Parts Inventory Issues, Parts Catalogue, Vendors, Parts Purchasing History, Vehicle Maintenance, Tire Maintenance, Maintenance Descriptions, Vehicle Types, Vehicles, and Maintenance Work Order. (Apollo Group, 2007). The expected end result from Huffman trucking is documentation showing entity relationship diagrams with referential integrity, data entry forms, SQL table join query code with results, and a normalized database that observes the business rules proposed by Huffman Trucking. Stages of Development In the first stage of development, we took the list of entities and their attributes proposed by our client and acquainted ourselves...

Words: 2177 - Pages: 9

Free Essay

Tim and Funding

...Few memories as a failure on a major project from half a decade ago still vividly remains in memories. As a Research Assistant to Tim, it was my first paid job. Tim, an Engineer, worked in silos and had driver social style to his heart beat. He only communicated the expectations without delving in the details that he had in his mind. Even though the Office space was a closed knit space for 16 students, Tim seldom hung out with people to build personal relationships. He only interacted with others when there was a need. His lack of explanation on why the project was needed had left me wondering regarding purpose and design aspects of the new programming project. I struggled on how to effectively design the project and often sought help from other people, who recommended me that the project needed investment in new programming platform as old platform was incapable of achieving the project objectives. After making almost no progress on the project and wasting time in attempts to make old platform workable, I received a vehement email from Tim, stating that XYZ Inc. was deciding to scale back on funding, as no progress reports were submitted. I was shocked to learn that I was even expected to submit progress reports at the end of quarter on the undertaken project in which I had neither any clue nor communication. As an amiable person, I was too quick to reach an agreement with Tim on project deliverables. I had thought that I would be receiving friendly advice and guidance from...

Words: 444 - Pages: 2

Premium Essay

Student

...and answer document, uploaded to D2L dropbox. You will have to find an IT professional to interview on your own.  Description of this assignment 1. Each student needs to find a candidate for a Post-implementation Review (PIR) report describing an information systems development project. 2. Where can you find an information technology professional to interview? You will have to find an IT professional to interview on your own.    3. If you work for a business or government organization, you should consider interviewing the IT/MIS director for your organization.  If you work P/T or F/T in any reasonably sized organization, it is likely that there are some IT workers around (like help desk staff, programmers, analysts, network technicians or even IT managers). It can even be a friend, relative or acquaintance you know who works in such a job. 4. The following is a list of themes that you could address in the interview: Please do not write this paper in question and answer format. Use the questions below to help guide the interview. ▪ What type of job does he/she do? For whom? ▪ What projects is he/she currently working on for the organization? ▪ What projects has he/she recently completed? ▪ What IT applications has the firm recently implemented? ▪ Were the most recently applications developed in-house, were they outsourced development or were they application software packages that were customized and purchased? ...

Words: 563 - Pages: 3

Premium Essay

Poo on Women: Is This Bad?

...Kempen | C402/C405 | Extend Diploma Mechanical Engineering EDENGM22A/B | Peter Kempen | C402/C405 | | GCSE English | Katherine Davey | G4 | GCSE English | Katherine Davey | G4 | | AS English Literature | Francesca Thomas | A58 | | | | | Archaeology: Unit 1 | Caroline Wilcox | B254 | Archaeology: Unit 2 | Caroline Wilcox | B254 | | Vocational Business assignment completion | Kemi Osoba | A49 | Vocational Business assignment completion | Bekoe Newman | A49 | | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | Spring Term Revision Schedule 2013-14 Week 1 | Tuesday 8th April | | Morning session 10.00-12.00 | Afternoon Session 1.00-3.00 | | Subject/course | Teacher | Room | Subject/course | Teacher | Room | | A2 Business (China Research Theme) | Nessa | A25 | AS Business | Nessa | A25 | | A2 Economics | Charles | G5 | AS Economics | Charles | | | AS Business | Sarah (11.00-12.30) | A39 | A2 Business (Higher level exam technique) | Sarah | A39 | | AS Law | Amina | A26 | | | | | Vocational Business assignment completion | Kemi Osoba | A49 | Vocational Business assignment completion | Bekoe Newman | A49...

Words: 883 - Pages: 4

Premium Essay

Microsoft Excel

...For ""Anticipated Project Size"" use your internal metrics as guidance. For example, if you use lines of code, then mentally assign ball park values to Small, Medium and Large as part of determining whether to give this criteria a high or low score. Follow a similar process ""Anticipated Duration"". Since project duration depends on project complexity, mentally categorize earlier projects as short, average or long duration to help put the current project in context. 2. After assigning a score for each criteria, view the Feasibility Study Suitability Indicator to discover the best method to use for determining project viability. 3. Omitted criteria will give an inaccurate result, so ensure all criteria are scored before checking the indicator." Criteria "Score (1=high, 3=low)" Guidelines Business Risk "1 = Significant, high-risk projects 2 = Low-to-modertate risk projects 3 = Small, low risk projects" Technology Risk "1 = Significant, high risk technological risks 2 = Low-to-moderate technological risks 3 = Small, low technological risks" Anticipated Project Size "1 = Large 2 = Medium sized 3 = Small" Anticipated Project Duration "1 = Long 2 = Medium duration 3 = Short" Project Dependencies "1 = Substantial and intricate project dependencies 2 = Minimal or manageable project dependencies 3 = No project dependencies" ...

Words: 451 - Pages: 2

Free Essay

Enterprenure

...(EPIEC) . From there he gained a lot of working experience and knowledge which made him to success in his business later . Business Motivation and starting One of the motivating factors was his father’s dream of his establishment in the society and another factor was after the independence of Bangladesh Aminul Islam realized that a new country has been born, therefore, a lot of construction will be needed for the development of the country and that is when he came up with the idea of Project Builders Limited. He proposed the idea to three other recent BUET graduates and they agreed to start with this new business. After the death of one of the partner and other two sold their share currently Aminul Islam is the only Managing Director and Chairman of Project Builders Limited. Vision The vision of Project Builders limited is to make quality constructions and make a strong infrastructure development of the country. Mission Construction of important structure and projects and to become the number one construction builder in Bangladesh. Initial Finance The company was initially started with four partners along...

Words: 2081 - Pages: 9

Free Essay

Kanpur

...knowledge to serve my best to the organization as well as my professional growth. Academics Relevant Courses: • Completed six weeks course and training in JAVA from SLR Infotech Pvt. Ltd, CHANDIGARH. • Pursuing 6 Months course and training in JAVA from DUCAT,NOIDA. • Completed six weeks course in C++ From ICT, KAITHAL B. Tech Projects: S.No Name Of the Project Description Team Members Roles and Responsibilities 1. CHANDIGARH TOURISM (B.Tech Summer Training Project) It was a software project based on core JAVA. It includes all the places to visit , map of chandigarh , hotel room booking , slides . Backend was based on MS-ACCESS . 2 Coding of Some pages, database manipulation & connectivity and preparing Crystal Reports. 2. DELHI TOURISM (B.Tech Minor Project ) It was a software project based on core JAVA. It includes all the places to visit , map of delhi , hotel room booking , slides . Backend was based on MS-ACCESS . 2 Coding of Some pages, database manipulation & connectivity and preparing Crystal Reports. 3. CRIME FILE MANAGEMENT (B.Tech Major Project ) It was a website describing various departments in crime department. It includes 3 modules WRITER , INSPECTOR , ADMIN. Writer writes complaints , Inspector investigates by watching the record using id’s and admin has all the controls. Platform used was ECLIPSE and backend was ORACLE database. 2 Overall designing of pages & coding of Admin Panel. Extra...

Words: 375 - Pages: 2

Premium Essay

Sharon Construction

...The following case represents a realistic situation facing construction firm that has just won a competitive contract. The realistic conditions complicating the project are described in detail, as are the alternatives offered by the staff for dealing with these complexities. Case The Sharon Construction Corporation The Sharon Construction Corporation has been awarded a contract for the construction of a 20,000-seat stadium. The construction must start by February 15 and be completed within one year. A penalty clause of $15,000 per week of delay beyond February 15 of next year is written into the contract. Jim Brown, the president of the company, called a planning meeting. In the meeting he expressed great satisfaction at obtaining the contract and revealed that the company could net as much as $300,000 on the project. He was confident that the project could be completed on time with an allowance made for the usual delays anticipated in such a large project. Bonnie Green, the director of personnel, agreed that in a normal year only slight delays might develop due to a shortage of labor. However, she reminded the president that for such a large project, the company would have to use unionized employees and that the construction industry labor agreements were to expire on November 30. Past experience indicated a fifty-fifty chance of a strike. Jim Brown agreed that a strike might cause a problem. Unfortunately, there was no way to change the contract. He inquired about...

Words: 918 - Pages: 4

Premium Essay

My Paper

...FOR PROJECT A Cash Flows DCF (13%) PV 350,000 0.8850 309,750 350,000 0.7831 274,085 350,000 0.6931 242,585 826,420 NPV = 826,420 – 735,000 NPV = 91,420 FOR PROJECT B Cash Flows DCF (13%) PV 300,000 0.8850 265,500 300,000 0.7831 234,930 300,000 0.6931 207,930 708,360 NPV = 708,360 – 690,000 NPV = 18,360 FOR PROJECT C Cash Flows DCF (13%) PV 200,000 0.8850 177,000 200,000 0.7831 156,620 200,000 0.6931 138,620 472,240 NPV = 472,240 – 600,000 NPV = (127,760) Assuming the cost of capital increase to 15%, the new NPV will be as follows FOR PROJECT A Cash Flows DCF (15%) PV 350,000 0.8696 304,360 350,000 0.7561 264,635 350,000 0.6575 230,125 799,120 NPV = 799,120 – 735,000 NPV = 64,120 FOR PROJECT B Cash Flows DCF (15%) PV 300,000 0.8696 260,880 300,000 0.7561 226,830 300,000 0.6575 197,250 684,960 NPV = 684,960 – 690,000 NPV = (5,040) FOR PROJECT C Cash Flows DCF (15%) PV 200,000 0.8696 173,920 200,000 0.7561 151,220 200,000 0.6575 131,500 456,640 NPV = 456,640 – 600,000 NPV = (143,360) At this point it is necessary for one to determine the sensitivity of the change in NPV of the three projects due to the increase in cost of capital. SUMMARY OF NPVS’ CALCULATIONS PROJECT | NPV @ 13% | NPV @ 15% | % CHANGE IN NPV | A | 91,420 | 64,120 | * 29.86% | B | 18,360 | (5,040) | * 127.45% | C | (127,760) | (143,360) | * 12.2% | From the table above it is clear that all three projects had...

Words: 350 - Pages: 2

Free Essay

Business

...selected a company in which they wanted to go with. Before the project began there are several things in which both the client and the consultant should cover before making an agreement to enter into a contract. The client and the consultant both should understand the risks of a project, the cost, rewards, and deadlines. There are three reasons for success or failure that could happen with the new project. One is the importance of the consultant competency and fit with the company needs. The consultant should be able to understand the company and what it does and its needs. It’s important In this case the consultant should ask themselves if this is something they are able to do. The second reason is the interpersonal fit between the consultant and the clients. The consultant should be able to speak with the client and feel they are going to be able to talk to them in regards to the business needs. Finally the last reason is if the consultant is able to establish ground rules for the consulting process. Being able to identify the rules before and making sure it’s something they can commit to will help both parties. Fullerton, Johanna; West, Michael View Profile The client and the consultant should both agree on the scope of the project, the project time line, what both parties are hoping to achieve , the client role vs. the consultant role, and finally how the client measure to the success of the project. www.partnercomm.net. When a client brings in a consultant...

Words: 1060 - Pages: 5

Premium Essay

Half Term Revision Dates

...Kempen | C402/C405 | Extend Diploma Mechanical Engineering EDENGM22A/B | Peter Kempen | C402/C405 | | GCSE English | Katherine Davey | G4 | GCSE English | Katherine Davey | G4 | | AS English Literature | Francesca Thomas | A58 | | | | | Archaeology: Unit 1 | Caroline Wilcox | B254 | Archaeology: Unit 2 | Caroline Wilcox | B254 | | Vocational Business assignment completion | Kemi Osoba | A49 | Vocational Business assignment completion | Bekoe Newman | A49 | | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | Vocational Sport and Travel Tourism assignment completion | Danny Chilvers | A50 | | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | AS /A2 GraphicsExtend Diploma Year 2 Final Major Project | Mark Pearson | Art Rooms | Spring Term Revision Schedule 2013-14 Week 1 | Tuesday 8th April | | Morning session 10.00-12.00 | Afternoon Session 1.00-3.00 | | Subject/course | Teacher | Room | Subject/course | Teacher | Room | | A2 Business (China Research Theme) | Nessa | A25 | AS Business | Nessa | A25 | | A2 Economics | Charles | G5 | AS Economics | Charles | | | AS Business | Sarah (11.00-12.30) | A39 | A2 Business (Higher level exam technique) | Sarah | A39 | | AS Law | Amina | A26 | | | | | Vocational Business assignment completion | Kemi Osoba | A49 | Vocational Business assignment completion | Bekoe Newman | A49...

Words: 883 - Pages: 4

Free Essay

Individual or Small Group Student Projects

...Individual or Small Group Student Projects Contacting Community Partners When contacting an outside organization about a service-learning project, you want to make sure to maintain a professional attitude. So how do you make the first call? Below follows a possible introduction to use when calling and making that first contact with an agency of your choice. Hello, my name is _______________________. I am presently enrolled in a ___________course at [name of campus]. My [instructor or Student Success Lead] gave me your name and number. I am very interested in doing a service-learning project for your agency. I want to apply the _________skills I am learning in my _________class to the volunteer position. When can I meet with you to discuss this further? If you have to leave a message, don’t be discouraged. Because many nonprofit and community agencies are understaffed, they might not return your call right away. Persistence is important in regards to making contacts and starting your service experience. More Communication Tips: When speaking to the site supervisor… * Ask about the organization’s volunteer policies and training guidelines. It is possible that you need to fill out additional paperwork with their agency as well as the GU/MSB/UCC paperwork. * Explain the course objectives (provided in your course syllabus) and tell them that you have __ service-learning hours to fulfill for your course. * Tell them your availability. What times are best...

Words: 365 - Pages: 2

Free Essay

Strategies to Make a Team Work

...slipping they can reach out to that team member to offer assistance or re-assign the project so that team doesn’t fail and that person doesn’t feel picked on by the whole team. It also defines who should be asking questions and for nobody again to feel picked on or singled out by another peer. Assignment of projects and ownership is crucial to this being a team effort that everybody has a stake in the outcome of the project. Goals, both short and long term are effective for setting a timeline on when certain parts of the project need to be completed in order for the next piece to start and to ensure we meet our deadline for turning in the project on time. Setting a regular meeting schedule is a little harder with our team being spread out all over three time zones, jobs and family. Our team has discussed at least posting once a day what is going on and their status. Example I was out of pocket for two days and my team had no idea what had happened to me till I returned to explain that I had been to a funeral out of town. If I had posted ahead of time, the team would have known what to expect and when I would be back to contribute my part. I can already see within my team alone that they have asked questions or worded things in another way to enlighten some things that were not exactly clear to me, so I do see the benefits already of working in this team environment instead of tackling these projects all on as...

Words: 327 - Pages: 2

Free Essay

Media

...document is intended as a guide for students to follow when preparing their internship reports. Submit the report to the course instructor (J. Flores or D. Wallace) after completing the internship activity: 1) Title Page 2) Table of Contents • Include an entry each main section as identified below (Introduction, Responsibilities, Major Projects, etc. • Provide an entry for each appendix, i.e., Appendix 1: Internship Proposal, Appendix 2: Documentation of Work Hours, etc.) 3) Introduction • Provide background information on the Company (paragraph). 4) Responsibilities • This should be a generalized description of Internship responsibilities (a couple of paragraphs at most). • Include a statement of the number of hours worked, with supporting documents in the Appendix. 5) Major Projects • Write summary descriptions for each major project, report, employee communication, or training packages developed (about a paragraph summarizing each) • Heading Examples: o Cyanide air sampling project o MSDS Inventory o Lead abatement project o Respiratory Protection Training o Compressor House Noise Survey o Acid tank ventilation project o Ergo Hazard evaluations • Provide examples of your work in an appendix (see below) 6) Internship Summary • Include pros and cons of your experience 7) Appendices • Include documents supporting the report, such as: o Internship Proposal o Documentation of Work Hours  A copy of check stubs showing first check and last check is...

Words: 311 - Pages: 2