ER DIAGRAM TOOL LUCID SOFTWAREThe work of Chen, Bachman, Brown, Martin and others also contributed to the development of Unified Modeling Language (UML), widely used in software design. Brown published works on real-world systems modeling. Bachman developed a type of Data Structure Diagram, named after him as the Bachman Diagram. Brown were working with close predecessors of Chen’s approach. It’s seen more recently in the 19th and 20th Century works of philosopher-logicians like Charles Sanders Peirce and Gottlob Frege.īy the 1960s and 1970s, Charles Bachman (above) and A.P.G. In a broader sense, the depiction of the interconnectedness of things dates back to least ancient Greece, with the works of Aristotle, Socrates and Plato. While serving as an assistant professor at MIT’s Sloan School of Management, he published a seminal paper in 1976 titled “The Entity-Relationship Model: Toward a Unified View of Data.” Peter Pin-Shan Chen), currently a faculty member at Carnegie-Mellon University in Pittsburgh, is credited with developing ER modeling for database design in the 1970s. I think good modelling the data often solves a lot of problems one may face later in their project.Peter Chen (a.k.a. The ER diagram for this WOD was :Īll in all I think it was a good revision of the ER diagrams and Lucidchart tool was simply wonderful to work with. Data can be interpreted in many ways and as far as it fulfils all the objectives, it is good. So I decided to ask him if such differences are ok and he said it was fine. When a customer returns a vehicle the clerk enters the date, the time, the odometer reading and whether the gas tank is full.”Īfter doing the first WOD this was a piece of cake, but again this time my entities were different from Prof. To make a reservation, a customer provides the location, the type of the vehicle and the day and time for which she/he would like to pick up and return the vehicle. A customer is usually identified by their phone number.Ī customer can reserve a vehicle for specific days, can rent a vehicle, or return the vehicle that she/he has rented. When a customer first rents a vehicle, the company records the customer name, address, and phone number. RentAJunker maintains a list of all their customers. Truck types include Box Trucks and Cargo Vans. The car types include: Economy, Standard, and Van. Each location maintains a number of cars and trucks. “Car rental domain modelĪ car rental company called RentAJunker keeps a number of offices in a variety of cities and locations within each city. Wod 2: For the second WOD, we had make an ER Diagram for a Car Rental domain model. But in the second attempt, I achieved Rx time. When I saw his, I realized mine was completely offtrack. I Dnfed the first time, mainly because my interpretation of the entities was quite different from Prof. The history of reservations for a book.Check which reservation should receive the newly turned in book.Check whether a copy of a particular title is loaned out or not.Check which books are out on loan to a particular borrow.Check which borrower has a particular book out on loan.Check whether a book being returned has been reserved.The Library staff needs to be able to do the following: Information to be stored includes: to whom a book is loaned the date a book is loaned the ISBN number, title, and author of a book the student or faculty member reserving a book, and the date reserved. Borrowers may make reservations when all copies of a book are out on loan. Several copies of the same book can exist for those in high demand. A student or faculty member can be loaned up to five books at a time. “At the Hamilton Library, students and faculty take out books on loan. WOD1: For the first WOD, we had to read a textual description of a library domain model and the ways the library data was manipulated, then generate an ER diagram representing this model. I have taken a database class before and this module was a great refresher. I had to make a lot of flowcharts in school and if I had known about this tool, it would have been a lot easier. Lucid chart is an HTML-5 based tool that made drawing the diagrams extremely fast and easy. ER DIAGRAM TOOL LUCID HOW TODeciding on tables, attributes and keys can be very tricky, and that is when Entity-Relationship diagrams come handy.įor this module we learnt how to make efficient ER diagrams using Lucid charts. If a mistake is made there, a lot can go wrong. I think designing the database is a very essential part of any project. This week it was data design modeling – the model in MVC architecture.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |