AdventureWorks Cycles is a boutique bicycle shop known for its high-quality bicycles, parts, and accessories. They operate from a physical store, where they sell and provide repair services for a variety of bicycles. The shop takes pride in its custom-made bicycles, like racing and mountain bikes, and offers an extensive selection of parts for cycling enthusiasts. Their racing and mountain bicycles differ in features such as speed, tire size, and design. Each bicycle has a unique serial number and model name. Racing bicycles are equipped with features such as, Material, Wheel size, Gear Ratio, Handlebar Type, Seat Post, and Weight. Mountain bicycles are designed for rugged terrain and feature knobby Tire treads, robust Brake types, stable Frame Geometry, and versatile Cranksets. AdventureWorks invites customers to bring in their bicycles for repair. The staff is composed of salespersons and mechanics, with each role requiring specific skills. Salespersons should have strong networking abilities, a high customer satisfaction score, and effective sales strategies, while mechanics are valued for their certifications and technical specializations. AdventureWorks Cycles emphasizes the importance of strong relationships with a network of suppliers to guarantee a consistent stock of bikes and parts. Occasionally, they may procure the same brands from different suppliers to maintain their inventory levels. The shop keeps records of bicycles and their corresponding parts, as each bicycle is composed of multiple components. Finally, AdventureWorks Cycles issues two types of invoices: one for customers who have purchased new bicycles and another for customers who have received repair services. In the repair invoice, we need to specify which mechanic repaired which bike for which customer