Competency AssessmentYou have been hired to create a relational database to support a car sales business. You need to store information on the business’s employees, inventory, and completed sales.You also need to account for the fact that each salesperson receives a different percentage of their sales in commission. What tables and columns would you create in your relational database, and how would you link the tables?Make a simple program (desktop) that implement your database designNote : Upload your Project Solution & Backup Database with your name as prefixDesigning a Relational Database
Proficiency AssessmentCreating Databases Using the SSMS Graphical InterfaceYour company, AdventureWorks, has decided to expand into interstellar travel. They haveasked you to create a new database called Planets on the Microsoft SQL server using theSSMS graphical interface. What steps would you complete to create this database?
Subscribe to view the full document.
Competency AssessmentScenario 2-2 Choosing Data TypesYou are designing several databases for a client. While designing the databases, you comeacross the following listed data items. Which data type would you use to store each of these pieces of information and why?•Radius of a planet•Value of pi •Salary•Person’s date of birth•Length of a board•Numbers of music players sold