Help with the evaluation item 2 for Erd You may receive assignment assistance for this within twenty-four hours at a cost of one hundred and twenty Australian dollars by contacting hndassignmenthelp@gmail.com. assignment assistance for the hnd general outline of the business case: CTD, which stands for cars-to-drive, is a franchised used automobile dealership that is located in the central business district of Sydney. They would want for their consumers to be able to examine the automobiles that are presented for sale on the internet, as well as to be able to monitor which automobiles are being sold and which other automobiles are in stock at each franchisee. You have been engaged by ctd to create a relational database in order to improve the tracking and recording of their operational data in accordance with the business principles that are given below: Within the Sydney metropolitan region, there are six separate sites where ctd dealers may be found. Of these locations, each location has just one dealer, who is the franchisee. A location code, the name of the site, the street, the city, the state, the postcode, and the phone number are all used to identify each and every location. Like a franchisee, a franchisee may be identifiable by a number, name, contact information, and so forth… The number of staff members that a franchisee hires at each store ranges from four to eight, with one of these staff members serving as the manager who oversees all of the other staff members and workers. In each site, the database is going to be used to store information on all of the workers as well as the management. There are many different kinds of automobiles that are kept at each location, and each category may have a range of automobiles that are of the same category. For instance, if a type is a commodore, then a range may be a commodore calais-v, a commodore evoke, and so on; however, each range is of only one type. The database is going to be used to store information on every single automobile type, range, year, and condition that is found in each and every area. The automobiles that were sold by each franchisee must also be recorded by ctd. This includes the kind and range of the vehicle, the date it was sold, and the salesperson who sold the vehicle. As a result, a franchisee may sell a large number of automobiles that are of the same model and range. Create an entity relationship diagram (ERD) that depicts the entities, characteristics, and connections between entities, as well as the cardinality and optionality of each relationship that are represented by this business rule. Display the main and foreign keys for each object in a straightforward and concise manner. note: in order to design your erd, you need make use of flow chart creator and online diagram program (https://www.draw.io). Notations based on the crow’s foot In the event that any m:n connection needs to be resolved to a 1:m relationship, it is not appropriate to manually draw the erd. This assignment requires that you submit your work online via the use of Turnitin. The specifics will be sent to you by the instructor of your topic. The purpose of this assessment item is to evaluate your comprehension of fundamental database architecture and modeling ideas, as well as your capacity to analyze business rules and incorporate them into an entity connection diagram. Additionally, your expertise in the use of appropriate relationships, cardinalities, and optionalities, as well as the utilization of crow’s foot modeling notations, will be evaluated.
I love myBlogd
Author
jackemails@gmail.com